Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 5589 Views
- Amdocs, I also Faced
- E-Mail Answers
How many Key we can define in remove duplicate stage?
What are the types of containers and how to create them?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
Difference in the implementation of lookup and join stages,in joining two tables?
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
What are some different alternative commands associated with "dsjob"?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
What is Cleanup Resources and when do you use it?
Which commands are used to import and export the datastage jobs?
Terminate Activity
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
Teradata 
