What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
No Answer is Posted For this Question
Be the First to Post Answer
what is data modeling?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
what make u disappointmnets in u r career
what are the data modeling tools you have used?(polaris)
how do u really know that paging to disk is happening while u are using a lookup transform?
What is the difference between round-robin partitioning and hash partitioning?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Explain about round-robi?
what are the facilities provided by data warehouse to analytical users?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?