Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3
Answer Posted / arjun
hi,
take aggrtr in that take one var , count the var group by i/p these go to one tgt and take another same tgt for that, take aggrtr ports i.e, i/p and var ports to filter in that give cndtion not isnull(var) and take i/p port to secnd tgt.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of transformation available in informatica.
What are the types of presistent cache in look up tr.
Explain informatica architecture - version 8 / 9
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How many numbers of sessions can one group in batches?
Do you find any difficulty while working with flat files as source and target?
4 yrs etl devloper roles and responsibilities?any body give solutions
What do you mean by blocking transformation?
Define mapping and session?
How to generate sequence numbers without using the sequence generator transformation?
Describe data concatenation?
What is the difference between a connected look up and unconnected lookup?
What is meant by active and passive transformation?
Explain about cumulative Sum or moving sum?
What are the components of the workflow manager?