Using Sql Query: SELECT eno, ename, date, edate, deptno FROM

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.

Question Posted / subhash

1 Answers
5668 Views
Amdocs, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How many types of views are there in a datastage director?

1296

Can you explain kafka connector?

1314

Distinguish between informatica & datastage. Which one would you choose and why?

1010

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5126

Explain the importance of surrogate key in data warehousing?

1193

What is the difference between orabulk and bcp stages?

1028

How do you schedule or monitoring the job?

1210

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1555

What are some different alternative commands associated with "dsjob"?

1169

What is meta stage?

1187

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1288

What are datastage sequences?

1126

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1233

What is job control?

1119

what is ds administrator used for?

1174