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
5744 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

root tree will find which is server job and which is parallel job?

2037

Explain entity, attribute and relationship in datastage?

1153

Differentiate between Join, Merge and Lookup stage?

1141

What are the main differences you have observed between 7.x and 8.x version of datastage?

1133

What are some prerequisites for datastage?

1168

AGGREGATOR default datatype

1520

What are the different common services in datastage?

1337

what is the difference between == and eq in UNIX shell scripting?

1556

Explain how a source file is populated?

1416

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2323

How rejected rows are managed in datastage?

1574

What a datastage macro?

1101

Explain usage analysis in datastage?

1223

Where the datastage stored his repository?

1138

What is meta stage?

1240