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

How will the document be delivered to me?

617


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1850


What is a node in Informatica?

620


tell me 5 session failure in real time how can you solve that in your project?

1631


Explain about Informatica server process that how it works relates to mapping variables?

622






Explain the code page compatibility?

643


Slowly changing dimensions, types and where will you use them

1272


How to join three sources using joiner?

571


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

625


Explain what is informatica metadata and where is it stored?

608


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

1467


What is the procedure for creating independent data marts from informatica 7.1?

566


How to update or delete the rows in a target, which do not have key fields?

651


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1870


What is meant by LDAP users?

695