What is data cleaning?
No Answer is Posted For this Question
Be the First to Post Answer
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
SCD2 will work on only dimension tables as well as fact Table?
how do u really know that paging to disk is happening while u are using a lookup transform?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
Can there be sub steps of etl steps?
How many types of transformations supported by sorted input?
What is Relational Integrity?
Explain what are the various etl tools in the market?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.