Define Routines and their types?
No Answer is Posted For this Question
Be the First to Post Answer
what are the types of nodes
what is a nodemap constraint
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
What is the difference between datastage and datastage tx?
why we use parameters instead of hard code 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.
What are the third party tools you used in your project?
DataStage Scenario based Interview Questions
how to write server Routine coding?
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
in oracle target stage when we use load option and when we use upsert option?