Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11221 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 oltp and olap?
What is transformation?
What are the features of complex mapping?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Write the program through which the records can be updated?
What is session task and command task?
How does a rank transform differ from aggregator transform functions max and min?
How can you increase the performance in joiner transformation?
What is resilience time?
What are the static cache and dynamic cache in informatica?
What are the new features of informatica 9.x developer?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What do you understand by term role-playing dimension?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
