what is meant by drill through?(Mascot)
By using Drill through, we can drill from one hierarchy to another hierarchy
Is This Answer Correct ? | 0 Yes | 0 No |
Explain about round-robi?
What is grain of fact?
what is Forward,Reverse and Re_engineering?
Do we need an etl tool?
Explain about the data integration suite features?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
SCD2 will work on only dimension tables as well as fact Table?
what are the different Reporting and ETL tools available in the market?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Explain the key challenges that you face while performing etl testing.
what is data modeling?
What are the three tiers in etl?