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
- 7406 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
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is the Rank index port in Rank transformation?
Explain what transformation and how many are there in informatica?
Explain target update override in informatica
What is rank index in rank transformation?
What are the types of schemas we have in data warehouse.
What is powercenter on grid?
What is a pre-defined event and user-defined event?
difference between informatica 8.1.1 and 8.6
What are the components of Informatica? And what is the purpose of each?
What is standalone command task?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what are the deliverables?in your project?
tell me the rules and responsblites in our project(my project is development)
