What is the difference between passive stage and active stage?
No Answer is Posted For this Question
Be the First to Post Answer
I have a few records just I want to store each records tow times in target how?
What is the use of surrogate key stage?
how to delete one row in target dataset
What is a datastage job?
What are the areas of application?
Where do you see different stages in the designer?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
How do u set a default value to a column if the column value is NULL?
Give an idea of system variables.
Why do you need stage variables?
how to add a new records into source?
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.