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
What are the main features of datastage?
What is a merge?
What are the important features of datastage?
How do u convert the columns to rows in datastage?
Name the command line functions to import and export the DS jobs?
Which commands are used to import and export the datastage jobs?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how to add a new records into source?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Can you explain kafka connector?
What are the different options associated with dsjob command?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How to implement complex jobs in data stage?
What is difference between symmetric multiprocessing and massive parallel processing?
how to abort the job its matain duplicates?