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
- 7535 Views
- Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the static cache and dynamic cache in informatica?
What is main use of mapplet?
Describe expression transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How do we call shell scripts from informatica?
What is the meaning of decode in informatica?
Mention few power centre client applications with their basic purpose?
Clarify the utilization of aggregator cache record?
What are the performance considerations when working with aggregator transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
list out all the transformations which use cache?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the new features of Power Center 5.0?
