DataStage Tips
DataStage tips is now active on datastagetipsntricks.blogspot.com
Home
How many records will be created in a dimension table when an employee moved from location X to location Y and then to Z from Y?
How will you implement SCD2?
What is the difference between flat table structure and dimensional structure?
How can we increment the surrogate key value for every insert in to target database?
Surrogate keys are used to join Dimension table to Fact table in a warehouse. True or False?
Which method is optimum to update the dimension table - 1. Direct update to the database in the same job using SCD. 2. By using SCD and creating a file with the change and using the file in next job?
What is the difference between Surrogate Key and Primary Key?
List down the different types of slowly changing dimensions.
What is data profiling?
List down the differences between a business process and subject area?
Can a fact table have many to many relationship with the dimensions?
What do you understand by measurement?
What are the goals of Data Warehouse?
What is metadata?
What are the different component of Data Warehouse?
In what scenario you would use a Surrogate Key Generator stage? Explain SKG.
What are Type 1 and Type 2 processing? Does SCD support these two types?
Older Posts
Home
Subscribe to:
Posts (Atom)
Popular Questions
How to improve performance of jobs by maintaining different DataStage directories?
How to fetch just first and last record from DataStage sequential file?
How can we do the incremental loading in datastage?
What is the difference between Lookup, Join and Merge stage?
What is Orchestrate Schema Definitions and why one should use it?
