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.
How many types of views are there in a datastage director?
how to implement scd2 in datastage 7.5 with lookup stage
Which type of joins Merge stage can support?
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
how to retrive the max(sal),deptno,empno in datastage?
Unix command to view the data in a dataset
Define Data Stage?
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
How to remove duplicates in transformer stage? in parallel mode
Explain the functionality of your current project?
1 Answers IBM, Miles Software,