source : col1 101 101 101 102 102 102 103 103 103
col2 1000 1500 2000 1200 2300 3000 2400 1300 2000
i need target as
col1 101 102 103
col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
- 6 Answers
- 9266 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / venky
src->exp->agg->tgt
exp transformation
col1
col2
var1=iff(var2=col1,var1||','||col2,col2)
var2=col1
output=var1
agg transformatiom
col1 select group
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences between joiner transformation and source qualifier transformation?
Explain the different lookup methods used in informatica?
Explain sessions. Explain how batches are used to combine executions?
Briefly define a session task?
Explain the different dimensions.
Describe data concatenation?
According to his methodology what all you need before you build a datawarehouse
What are Dimensional table?
what is the complex transformation you used in informatica
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What does command task mean?
Explain load alternative records / rows into multiple targets - informatica
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
without table how to come first record only in oracle?
What is the difference between a repository server and a powerhouse?
