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
- 9378 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 |
Performance tuning( what you did in performance tuning)
what is incremental data aggregation?
What are the issues you have faced in your project? How did you overcome those issues?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
Performance wise which is better joiner or look up ? Give me with example?
what is mystery dimension?
what is the hint? how to use it to reduce the query processing in program?
tell me the push down optimization
Is there any model difference between ODS and DWH
Tell me about Propagate functions in informatica
what is size of u r database?
Teradata 
