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
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Can we create a node as a gateway node and the same node can be assigned to a grid?
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain lookup transformation source types in informatica
What are the various types of transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How do you set a varible in incremental aggregation
Where can we find the throughput option in informatica?
To import the flat file definition into the designer where should the flat file be placed?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
State the limitations where we cannot use joiner in the mapping pipeline?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the different types of olap? Give an example?
Explain dynamic target flat file name generation in informatica
What are the tuning techniques you applied during your last project