can we load the data with out a primary key of a table?
what is target plan?
- 6 Answers
- 13607 Views
- IBM, I also Faced
- E-Mail Answers
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
How to do unit testing in informatica?
What do you mean incremental aggregation?
How an expression transformation differs from aggregator transformation?
What is a repository? And how to add it in an informatica client?
What are the different types of olap? Give an example?
What is the benefit of session partitioning?
What is the function of union transformation?
How do you set a varible in incremental aggregation
how to load dimension table and fact table. plz tell me the steps.
If informatica has its scheduler why using third party scheduler?
Enterprise data warehouse your projects phase by phase explain?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
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.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain scd type 3 through mapping.
