I have source like col1,col2,col3,col4 and the values are like
3,6,1,7
1,5,3,8
2,1,5,6
i want the output like
3,6,7
5,3,8
2,5,6
How we will achieve in this scenario in informatica level.
Please help me..
Thanks in advance..
Answer Posted / krishna prasad
use the filter transformation
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What are connected or unconnected transformations?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are batches?
what is $$$$?
What is the advantage of informatica?
Please let me know how to make encryption and decryption with example?
What is a repository? And how to add it in an informatica client?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Enlist few areas or real-time situations where informatica is required.
How to partition the Session?
What is Cognos script editor?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Differences between version 7.x and 8.x.
How to implement security measures using repository manager?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?