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.
Answer Posted / subhash
Using Sql Query:
SELECT
eno, ename, date, edate, deptno
FROM INPUT_TABLE
WHERE edate IS NULL
ORDER BY eno;
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Describe link sort?
What are stage variables and constants?
What is the difference between server job and parallel jobs?
What is the use of datastage director?
Why fact table is in normal form?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the purpose of interprocessor stage in server jobs?
Can you explain engine tier in information server?
How do you import and export the datastage jobs?
What are the main features of datastage?
What is use Array size in datastage
How many Key we can define in remove duplicate stage?
root tree will find which is server job and which is parallel job?
Explain the situation where you have applied SCD in your project?
What are the steps required to kill the job in Datastage?