Answer Posted / ash
By Default the intergration service updates the target
based on key columns. But we might want to update non-key
columns also,at that point of time we can override the
UPDATE statement for each target in the mapping.The target
override affects only when the source rows are marked as
update by an update strategy in the mapping.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
what is mean by complex business rule ?
How do you load unique records into one target table and duplicate records into a different target table?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
explain abt ur project architecture?
What is a snowflake schema?
How can we delete duplicate rows from flat files?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
what is song in infrmatica...?
what is SDLC way of code development?
Write the program through which the records can be updated?
What is different between the data warehouse and data mart?
EXL informatica Questions
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
how to load rows into fact table in data warehouse
is it possible to index the data in cache of lkp transformation ?
