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
Explain the pipeline partition with real time example?
How will the document be delivered to me?
What is incremental aggregation?
What is data caches/ index caches?
How many input parameters can exist in an unconnected lookup?
Write the different tools in the workflow manager?
How to update a particular record in target with out running whole workflow?
What are the new features of informatica 9.x developer?
What is rank transformation?
Please let me know how to make encryption and decryption with example?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
permutations of mapplet
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is sequence generator transformation in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?