Slowly changing dimensions, types and where will you use them
No Answer is Posted For this Question
Be the First to Post Answer
What are the different components of powercenter?
What are the informatica performance improvement tips
What is pmcmd command?
what is threshold error in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what is constraint based load order
what is hash table in informatica?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
Mention few advantages of router transformation over filter transformation.
Discuss the advantages & Disadvantages of star & snowflake schema?