How you Implemented SCD Type 1 & Type 2 in your project?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between operational data stage (ods) and data warehouse?
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
how to change left and right links in join stage?
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
How can we do null handling in sequential files
How can u write exception handling in seq file????
How to reverse the string using SQL?
can we half project in parallel jobs and half project in server jobs?
What is ibm datastage flow designer?
describe the Steps to confiure a Qlogic switch
what is advantages of snowflake when it is used?
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.