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
- 7410 Views
- Ness Technologies, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / babu
Hi raviKumar,
I think u r question has small mistake that is first data
has to load in T1 then only load T2.
By using "Constraint Based load ordering" option u can
achieve this.This option is available in 'Config object'
tab in Session Tabs
(General,Properties,Config
objects,Mapping,Components,Metadata Extensions)
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
What is the need for an etl tool?
what are the transformations that restricts the partitioning of sessions?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
Explain reference cursor?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
What is a parameter When and where do you them when does the value will be created
What are the different options available for update strategy?
What is a joiner transformation?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
Teradata 
