can we load the data with out a primary key of a table?
what is target plan?
- 6 Answers
- 13608 Views
- IBM, I also Faced
- E-Mail Answers
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 sorter transformation?
what is the difference between informatica6.1 and infomatica7.1
draw informatica architecture 8.6 ?
Why sorter is an active transformation?
Where can we find the throughput option in informatica?
How to load last n records of file into target table - informatica
How to extract sap data using informatica? What is abap? What are idocs?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is informatica metadata and where is it stored?
Differentiate between joiner and lookup transformation?
How to generate sequence numbers?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Does an informatica transformation support only aggregate expressions?
What do you mean by filter transformation?
