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


Please Help Members By Posting Answers For Below Questions

What are connected or unconnected transformations?

620


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

626


What are batches?

611


what is $$$$?

1724


What is the advantage of informatica?

641






Please let me know how to make encryption and decryption with example?

1453


What is a repository? And how to add it in an informatica client?

640


hi real timers . iam waiting for ur reply regarding ETL TESTING

1798


Enlist few areas or real-time situations where informatica is required.

583


How to partition the Session?

638


What is Cognos script editor?

3780


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

706


Differences between version 7.x and 8.x.

1413


How to implement security measures using repository manager?

595


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?

649