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
- 9341 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 |
how DTM buffer size and buffer block size are related
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
What is the difference between bitmap and btree index?
What is rank transformation in informatica
If we have lookup table in workflow how do you trouble shhot to increase performance?
What are the parts of Informatica Server?
what is the purpose of surrogate key and diff between primary key&surrogate key
If u r using dynamic cache lookup port will be thier in thet which option u will select
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
task is running successfully but data is not loded why?
in which situations do u go for starflake schema ?
Teradata 
