Answer Posted / ram kumar
SCD 2 is critical Mapping
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Design a mapping to load a target table with the following values from the above source?
Explain sessions. Explain how batches are used to combine executions?
What is aggregate cache in aggregator transformation?
How are the sources and targets definitions imported in informatica designer?
What are the modules in Power Center
Which is the t/r that builts only single cache memory?
How to start a workflow using pmcmd command?
What is the scenario which compels informatica server to reject files?
What are the transformations that are not supported in mapplet?
which one is better performance wise joiner or look up
Which means the first record should come as last record and last record should come as first record and load into the target file?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what is the Default Source Option For Update Strategy Transformation?
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?
