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
permutations of mapplet
Explain what are the different versions of informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are mapplets? How is it different from a Reusable Transformation?
What is a joiner transformation?
waht type of interface is used for testing the data in informatica
What does refresh system mean, and what are its distinctive choice?
What does reusable transformation mean?
What the difference is between a database, a data warehouse and a data mart?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is enterprise data warehousing?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is a dimensional model?
What is deployment group?