Answer Posted / chandrasekar
Whenever an OLTP records update or insert in the source
,then the records are loaded in to target as a new record.
Using SCD type 2 we can acheive the incremental load.
If it wrong means chandranmca2007@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
explan ur project architecture?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is deployment group?
What are the modules in Power Center
have u done any performance tuning? how u ll do?
Explain informatica architecture - version 8 / 9
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is a difference between complete, stop and abort?
State the limitations where we cannot use joiner in the mapping pipeline?
can we override a native sql query within informatica? Where do we do it?
How many number of sessions can one group in batches?
Briefly explain the aggregator transformation?
What is a passive transformation?
How to extract the informatica rejected data?
What are active transformations.
