Define Update Override?
Answer / 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 |
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
What are differences between Informatica 7.1 and 6.1
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
What are pre and post-session shell commands?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
Which means the first record should come as last record and last record should come as first record and load into the target file?
why we use datawarehouse
how to return multiple columes through through un-connect lookup?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
How to load the source table into flat file target(with columns) in informatica?
What are the parts of Informatica Server?