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

Difference between server jobs & parallel jobs?

1019

What is process model?

1926

How to clean the datastage repository?

1071

How do you import and export data into datastage?

1171

How many types of sorting methods are available in datastage?

1020

What is the difference between passive stage and active stage?

1419

What is the use of hoursfromtime() function in transformer stage in datastage?

1005

What are the different kinds of views available in a datastage director?

977

What is the method of removing duplicates, without the remove duplicate stage?

967

what are the devoleper roles in real time? plz tell i am new to datastage....

2102

What are the features of datastage flow designer?

993

How complex jobs are implemented in datstage to improve performance?

967

How the ipc stage work?

1081

sed,awk,head

1412

What is the purpose of pivot stage and types of containers in datastage

996