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

Whats difference betweeen operational data stage (ods) and data warehouse?

1111

What is the command line function to import and export the ds jobs?

1151

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

How many types of stage?

1177

Terminate Activity

1278

Differentiate between hash file and sequential file?

1071

Describe the main features of datastage?

1076

What is the difference between informatica and datastage?

1221

What is the difference between datastage and datastage tx?

1064

What are the benefits of datastage?

1238

how to delete one row in target dataset

3120

what is 'reconsideration error' and how can i respond to this error and how to debug this

2630

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

1276

How do you reject records in a transformer?

1122

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

2277