can we load the data with out a primary key of a table?
what is target plan?
Answer Posted / sbvp
acutally we need pk for updating records while using update
strategy t/r. if we want load the data into the target with
out pk is possible. while we don't create pk,fk in tgrt
table we will use bulk loading but there is no recovery
option for bulk loading. if u want recovery option for ur
mapping u can use normal trgt load type ok.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Whats there in global repository
What are the components of workflow manager?
how tokens will generate?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
pmscmd startworkflow -sv
complex mapping ur project u r invlve can u explain and give real time example give me ?
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.
What are active and passive transformations?
What is the sequence generator transformation in informatica?
Target increases every day even though no new record was inserted
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is informatica metadata?
What is rank transformation?