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
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
explain abt ur project architecture?
What is intricate mapping?
According to his methodology what all you need before you build a datawarehouse
what is degenerated dimension?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain in detail scd type 2 through mapping.
Define update strategy?
How to do unit testing in informatica? How to load data in informatica ?
What is mapplet in informatica?
What is the benefit of session partitioning?
Explain the pipeline partition with real time example?
can anyone suggest best free Talend data integration training online
Explain lookup transformation is active in informatica
What is the use of code page?
How to create the source and target database connections in server manager?