Interested to Buy Any Domain ? << Click Here >> for more details...
My source has 100 records. I have targets say in number 5.
all target tables has parent and child relationships in
between themselves. Now I want to load all 100 records into
all targets. How U can ensure that record inserted in parent
and then loaded into child.
- 3 Answers
- 9392 Views
- Cognizant, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / veeru
use the constrinat based loading order in session level and
set the dependency
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / rekha
By using constraint load ordering in session level (gofor
config tab -->, then 1st option is constraint based load
ordering) we can achieve this
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / naveen
Use the target load plan & constriant based loading order in
session level and set the dependency
| Is This Answer Correct ? | 1 Yes | 2 No |
Howmany ways yoU can update a relational source defintion and what are they?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
 Code page compatibly –Where all changes are made to handle the scenario.
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
What are the limitations of joiner transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Can we create multiple integration service on single repository?
Differentiate between router and filter transformation?
can we generate reports in informatica ? How?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
Teradata 
