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
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to extract the informatica rejected data?
How are indexes created after completing the load process?
How can we remove the duplicates from flat file source?
what is the hint? how to use it to reduce the query processing in program?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the function of union transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is meant by pre and post session shell command?
What are the various types of transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Clarify the utilization of aggregator cache record?
Can we override a native sql query within informatica?
What is native users?