Explain what are the various etl tools in the market?
No Answer is Posted For this Question
Be the First to Post Answer
what is session partitioning?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is tracing level? How many types of transformations supported by sorted input?
what are the session parameters? How do u set them?
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
how would u estimate the size of Aggregator transform data and index cache?
what is the difference between cubes and package in cognos
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
what are the different forms of normalization?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
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?