how can or from where we can get reference data in scd type2
implementation?
Answers were Sorted based on User's Feedback
Answer / d anil babu
in change capture before data.or intial load data take refence
for delta load.
Is This Answer Correct ? | 0 Yes | 2 No |
what is factless fact table?
difference between server shared container and parallel shared container
Can you highlight the main features of ibm infosphere information server?
What is lookup table?
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
what is advantages of snowflake when it is used?
what is the best stage in datastage parller jobs to use full out join and why
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
How did you reconcile source with target?