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
- 7312 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 are session parameters ? How do you set them?
What are reusable transformations in how many ways we can create them?
if the session fails after 100 records agian we have to starts the session or we go for recovery session
How to generate sequence numbers?
what is upstream and downstream transformation?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
Design time, run time. If you don't create parameter what will happen
why dimenstion tables are denormalized in nature ?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
Teradata 
