HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
Answer Posted / tulasi pavani.k
If two flat files are of same structure we can join by
creating one list file and by writing the the names of those
two flat files in one text file.
source file directory:c:/order.txt
source file type:indirect
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How can informatica be used for an organization?
How do you migrate data from one environment to another?
Informatica Checkpoints
Slowly changing dimensions, types and where will you use them
What are the mapping parameters and mapping variables?
What is the status code in stored procedure transformation?
Differentiate between a repository server and a powerhouse?
Define sessions in informatica etl?
Which version configuration tool used in ur project?
What is the scenario which compels informatica server to reject files?
What is transformation?
How can we update a record in the target table without using update strategy?
What is depict expression change?
What is a filter transformation?