Interested to Buy Any Domain ? << Click Here >> for more details...
I have a scenario which load the data frm single source to
2 targets as T1, T2, and T1 have a P.K and T2 have F.K
relations. first data has to load in T2, and then data load
to T1 if that record exist in T1... how can we acheive it?
- 2 Answers
- 7364 Views
- Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / siva
We have to take the 2 source instances of the same source
say S1 and S2.
Do the mapping from S1 to T1 and then S2 to T2 by making
lookup on T1. i.e. in same mapping 2 different pipelines.
Go to Mapping Tab --> Target Load Plan
It will show the list of two Source Qulifiers.
Then set the Target Load Plan sequence as first SQ1 and then
SQ2. This will first load T1 and then load T2 by making
lookup on T1.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the different lookup cache(s)?
What are the types of lookup transformation?
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 ?
What all join we can perform in LOOKUP transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain the pipeline partition with real time example?
What are the main issues while working with flat files as source and as targets ?
How to open an older version of an object in the workspace?
Explain what are the different types of transformation available in informatica.
Define pmcmd command?
What are the components of workflow manager?
What is dimensional table? Explain the different dimensions.
How to generate sequence numbers without using the sequence generator transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
