can we load the data with out a primary key of a table?
what is target plan?
Answer Posted / suresh
we can load data without primary key but if whenever u need to update the table from informatica then u have to use update override then only u can update the table.
target plan: if u have maultiple source and multiple targets in one mapping then u have to go target load order this option available in mapping tab
correct me if i wrong
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are roles and groups and benefits of using them?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How do you convert single row from source into three rows into target?
To import the flat file definition into the designer where should the flat file be placed?
What are the types of caches in lookup? Explain them.
What is the need of etl tools?
is it possible to index the data in cache of lkp transformation ?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Explain the difference between mapping parameter and mapping variable?
Can we create multiple integration service on single repository?
What do think which one is the better joiner or look up?
Describe expression transformation?
Explain how to import oracle sequence into informatica?
What does command task mean?