Answer Posted / shweta
One clarification to the fisrt point,it ingnores the commit
point only while loading to Sybase and DB2 whereas for
Oracle and SQL Server, it commits data at each commit
interval and start a new transacton after each commit.
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is core dimension?
What is partitioning? What are the types of partitioning?
What is a core dimension?
What is the difference between static cache and dynamic cache?
What are the different methods of loading dimension tables?
How to import vsam files from source to target. Do we need a special plugin?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
After the complete generation of a report who will test the report and who will analyze it?
Can you pass sql queries in filter transformation?
How can you set the client management?
Explain the structure of cold fusion?
What is a full backup?
How to pivot data using informatica when you have variable amount of pivot rows?
Explain meta data?
Explain the definition of normalized and denormalized view and what are the differences between them?