-
Target Size
What is the normal size of data warehouse in a project?
-
Fact Table Duplicates
How can we remove duplicates from fact table?
-
Stage Variables Initialization
What are the initial values of stage variables? How can we set this values?
-
Lookup and Change Capture
What is the difference between Lookup & Change Capture Stages?Can we change capture stage instead of Lookup?
-
Flat File Header and Footer
Does flatfile contain header & footer?How to remove Header & Footer from a flatfile before extracting the data?What information header & footer contains?
-
Flatfiles Validations
When we are extracting the flatfiles, What are the basic required validations?
-
Calculation Without using Aggregator
How to calculate Sum, Averages, Minimum, Maximum salaries of an employee without using Aggregator stage in datastage?
-
Sequential File Stage Duplicates
How to remove duplicates through only sequential file stage?
-
Degenarated Dimension
What is the use of Degenerated dimension? Where it is used?
-
Custom Dimensions
What is a custom dimension?
-
Transformer Stage Functions
If you have Numerical+Characters data in the source, how will you load only Character data to the target? Which functions will you use in Transformer stage?