Answer Posted / abhinaw prakash
When we want to Update the Target without any Primary key
but with matching columns then we ll go for Target update
override.
The Integration service outputs a Default query,we need to
make the changes according to the column we want to Update.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain why we use partitioning the session in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is standalone command task?
How many transformations can be used in mapplets.
What is the advantage of informatica?
Where are the source flat files kept before running the session?
What is the commit type if you have a transaction control transformation in the mapping?
How you know when to use a static cache and dynamic cache in lookup transformation?
what is mean by complex business rule ?
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?
Explain the different kinds of facts.
Explain sql transformation in script mode examples in informatica
State the limitations where we cannot use joiner in the mapping pipeline?
Explain what is informatica metadata and where is it stored?
Explain lookup transformation is active in informatica