HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
Answer Posted / murali udayagiri
Use join UNIX command in pre-session command for joining
both the files and write to a file. Use single SQ trans in
mapping to read that joined flat file data.
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to extract sap data using informatica? What is abap? What are idocs?
without table how to come first record only in oracle?
What are the mapping parameters and mapping variables?
What are the different types of repositories created using informatica?
What is the cumulative sum and moving sum?
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 are the databases that informatica can connect to windows?
How many transformations can be used in mapplets.
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?
Separate from an archive server and a powerhouse?
How does the aggregator transformation handle null values?
What are the various types of transformation?
How to create or import flat file definition in to the warehouse designer?
What's the layout of parameter file (what does a parameter file contain?)?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance