Explain the importance of surrogate key in data warehousing?
No Answer is Posted For this Question
Be the First to Post Answer
What all are the different way to run a job?
how can we create rank using datastage?what is the meaning of rank?
How to display all the duplicate records from the oracle Table?
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How can remove duplicates in a file using UNIX?
count number of deptno in a emp table?
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
Can we use target hash file as a lookup ?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
How many types of views are there in a datastage director?
Is possible to create skid in dim,fact tables?