1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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


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

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  

Name the different types of Lookups in Datastage?

0 Answers  

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

how can we extract data with out having any common column

7 Answers   IBM, Switch2iTech,

How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers   Cap Gemini, TCS,




there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,

Describe stream connector?

0 Answers  

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

what is .dsx files

3 Answers   IBM,

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

For more Data Stage Interview Questions Click Here
Categories