Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
- 2 Answers
- 10514 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajasekhar.
we can create a parameter file as previous_run_time and
current_run_time in the mapping. based on this time stamps
we can capture the new records which need to be insert and
update in the target table.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is Session and Batches?
Differentiate between reusable transformation and mapplet.
What are roles and groups and benefits of using them?
how many types of dimensions are available in informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is persistent lookup cache?
scenario where i can use only concurrent execution of workflow.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What happens when a session fails and you click on recover?
Define enterprise data warehousing?
Differentiate between router and filter transformation?
How do you load only null records into target?
