Explain the importance of surrogate key in data warehousing?
No Answer is Posted For this Question
Be the First to Post Answer
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
What are the benefits of datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How many number of reject links merge stage can have?
Define data aggregation?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the components of ascential data stage?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
which memory is used by lookup and join
Explain the situation where you have applied SCD in your project?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
How do you load dimension data and fact data? Which is first