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
What is meant by a domain?
How to differentiate between the active and passive transformations?
4 yrs etl devloper roles and responsibilities?any body give solutions
How many types of sessions are there in informatica.please explain them?
How big was your fact table
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the main features of Oracle 8i with context to datawarehouse?
How might you approve all mappings in the archive all the while?
Explain pushdown optimization and types in informatica
What is data caches/ index caches?
How do you use reject loader.
server hot-ws270 is connect to Repository B. What does it mean?
What is parallel processing in informatica?
What is update strategy transform?
Explain sessions. Explain how batches are used to combine executions?