In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What are snapshots?
What are the differences between sql override and update override?
What is partitioning? Explain about round-robin, hash partitioning.
Explain about hash partitioning?
How many types of transformations supported by sorted input?
How to fine tune mappings?
What is a mapping, session, worklet, workflow, mapplet?
What is etl process?
What is tracing level? How many types of transformations supported by sorted input?
Explain what are the various etl tools in the market?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Explain do we need an etl tool? When do we go for the tools in the market?
Explain do we need an etl tool?
When do we go for the tools in the market?