Why should we use data ware housing and how can you extract data for analysis with example?
TCS,
637
How the Bursting happens in same report and how to Print the bursting Report?
what is session partitioning?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How can one identify whether mapping is correct or not without connecting session?
Syntax for case when statement?
Identifying the bottlenecks in various components of Informatica and resolving them.
Explain what are non-additive facts in detail?
How are models actually derived?
how to abort the job its matain duplicates?
Why is data processing considered beneficial?
What is AWS Redshift is used for ?
Can you explain engine tier in information server?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is an i-server?
what is degenerate key in oracle ?whare do we use it?