how to join two flat files in informatica?
Answers were Sorted based on User's Feedback
If the structure of the two flat files is same we can use SQ.by using in direct
if there is no common field in the two flat files then
create dummy columns in the exp t/r and then by using the dummy columns u can join them in the joiner t/r by giving the condition dummy = dummy1.
the flow is like this
src1--->SQ----->exp--->
|--->joiner---->target
src2--->SQ----->exp--->
| Is This Answer Correct ? | 10 Yes | 0 No |
Hi Rajesh
could you plz tell me the steps to join from joiner tr.
Regards
Mehul Thakur
| Is This Answer Correct ? | 0 Yes | 1 No |
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
Describe the impact of several join conditions and join order in a joiner transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
what is degenerated dimension?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How do you convert single row from source into three rows into target?
Enlist the tasks for which source qualifier transformation is used.
what is polling?
Different sorts of metadata that stores in the storage facility?
What is the difference between STOP and ABORT options in Workflow Monitor?