can we load the data with out a primary key of a table?
what is target plan?
Answer Posted / koti
by using update overide option we can update the target
though we dont have any primary key in target.
target overload means some time in a single mapping no. of
targets can take place one source can be depend on other
target. then we have to decide which target has to execute
first....
ex: source1.... target1(date of birth is one column in
target 1)
source2(age is one column is source2).... target2
in the above example target1 should be execute first. then
only we can get age in source 2. because age is depends on
date of birth which is available is target1...
hope u understood. if any clarification mail to me:
manjulakoteswararao@gmail.com
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain scd type 3 through mapping.
Why update strategy and union transformations are active? Explain with examples.
What differs when we choose the sorted input for aggregator transformation?
What is a pre-defined event and user-defined event?
What is Session and Batches?
Whats there in global repository
what is the size ur source like(file system or database)? how many record daily come u r banking project?
In warehouses how many schemas are there?
Explain joiner transformation in informatica
What is InformaticaPowerCenter?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a standalone command task?
What are the different lookup cache(s)?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Implementation methodology