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
- 7536 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
Plz can any one say me how to get the informatica certification materials and dumps
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Write the program through which the records can be updated?
scenario where i can use only concurrent execution of workflow.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is complex mapping?
What is data movement mode in Informatica and difference between them?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is data transformation manager process?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Sequence generator, when you move from develoment to production how will you reset
Describe an informatica powercenter?
what is informatica metadata?
Where do we use mapping variables in informatica?
How to create Target definition for flat files?
