Hi dude, i/p eno ename date edate deptno 1 x 10thjuly

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 / suneel

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

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 ..

Answer / 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

More Data Stage Interview Questions

which r the connectors used in san?

0 Answers

what is operator combinality in datastage?

1 Answers TCS,

what are fact tables and dimension tables? give example assuming one table.

3 Answers IBM,

How to display errors in datastage?

1 Answers TCS,

How a routine is called in datastage job?

0 Answers

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers Cognizant, IBM, TCS, Virtusa,

can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

4 Answers IBM,

Define Merge?

0 Answers

how to retrive the max(sal),deptno,empno in datastage?

13 Answers Polaris,

For more Data Stage Interview Questions Click Here