Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
count number of deptno in a emp table?
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
What is the difference between Datastage 7.5 and 7.0?
Explain connectivity between datastage with datasources?
How many types of views are there in a datastage director?
How to implement complex jobs in data stage?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
How complex jobs are implemented in datstage to improve performance?
what is data mapping
What is the different type of jobs in datastage?
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.