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.
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 |
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
What is the difference Between Mapping parameter and variable
Can anyone briefly describe abt audit table loading?
Why update strategy and union transformations are active? Explain with examples.
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
How u use pdf file in informatica source?
can session assigned multiple mappings or not?
how we can load rejected record's at run time?(not through bad files)
In development project what is the process to follow for an etl developer from day1
What will be the approach?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?