Interested to Buy Any Domain ? << Click Here >> for more details...
If we have 1000 rows were loaded in to datawarehouse and
next day the source have 1010 rows so, how can we loaded
only updated rows into target.
- 6 Answers
- 11912 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / mahipal reddy
By selecting 'UPDATE' in the 'Treat source data as:'from
session properties we can get only updated rows..
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What are session parameters ? How do you set them?
What is DR strategy for Informatica project?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is a transaction control transformation?
Explain sessions. Explain how batches are used to combine executions?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How you prepared reports for OLAP?
What is Cognos script editor?
Do you find any difficulty while working with flat files as source and target?
What is the use of source qualifier?
What does cheating measurement mean?
What is the difference between source qualifier transformations source filter to filter transformation?
What's the layout of parameter file (what does a parameter file contain?)?
Define sessions in informatica etl?
