Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

Give an idea of system variables.

0 Answers  

How to Convert the columns into rows?

2 Answers  

What is the difference between operational data stage (ods) and data warehouse?

0 Answers  

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

job locking methods? How can we unlock the job?

3 Answers   IBM,

What is RCP

5 Answers   CGI, CTS,

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

0 Answers  

What is the difference between hashfile and sequential file?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories