What is up date strategy and what are the options for update
strategy?
Answer Posted / jyothi
Update strategy is used for flagging the records by using
the options insert/update/delete/reject.
Update strategy is used in two levels.
session level:at session level we have to use the options
update as insert,update as update,update else insert.
mapping level:at mapping level we have to use the options
dd-insert,dd-update,dd-reject,dd-delete.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Mention few power centre client applications with their basic purpose?
According to his methodology what all you need before you build a datawarehouse
can we override a native sql query within informatica? Where do we do it?
What is aggregate cache in aggregator transformation?
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
Explian the Process of deployment groups in informatica
Define mapping and session?
Explain pushdown optimization and types in informatica
Explain lookup transformation in informatica
tell me about your project functionality
Why update strategy and union transformations are active?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is meant by a domain?
What are the types of schemas we have in data warehouse.