When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
No Answer is Posted For this Question
Be the First to Post Answer
What is data cleaning?
what happens if the info.server doesn't find the session parameter in the parameter file?
what are the facilities provided by data warehouse to analytical users?
Mention few test cases and explain them?
where we cannot use sorter Transformation. if we use then we will not get correct data?
Explain the use lookup tables and Aggregate tables?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
what happens if the info.server doesn't find the session parameter in the parameter file?
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?
What is granularity? Please explain with example
What is the difference between round-robin partitioning and hash partitioning?
What is partitioning? Explain about round-robin, hash partitioning.