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
- 10828 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 types of schemas we have in data warehouse and what are the difference between them?
Why update strategy and union transformations are active?
How to delete duplicate row using informatica?
Enlist few areas or real-time situations where informatica is required.
Enlist some properties of sessions.
can we override a native sql query within informatica? How do we do it?
Which are the different editions of informatica powercenter that are available?
Why union transformation is an active transformation?
What is rank transformation in informatica
Explain in detail about scd type 1 through mapping.
how to load dimension table and fact table. plz tell me the steps.
How to join three sources using joiner?
Mention few power centre client applications with their basic purpose?
What is the difference between stop and abort in informatica
Differentiate between sessions and batches?
