what is the use of surogate key in datastage
No Answer is Posted For this Question
Be the First to Post Answer
how to handle null values in sequential file?
What are the areas of application?
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.
Difference between sequential file and data set?
Is possible to create skid in dim,fact tables?
How many areas for files does datastage have?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
Tell me the syntax of Configuration file?
What's the Main Function of the Staging area in DWH
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?