What is an IDQ file? What is the purpose of the IDQ file and
what kindof information does it usualy hold? Can it be
imported by informatica?
No Answer is Posted For this Question
Be the First to Post Answer
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is the difference between snowflake and star schema?
What is data warehouse architecture?
How to load the time dimension?
What are the key columns in Fact and dimension tables?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is a source qualifier?
What a static and local variable?
How did you plan your Data ware house project?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Can we take backup when the database is opened?
Explain what are the vaious etl tools in the market?