There are two file are there .1st file contains 5 records and
2nd file contain 10 records in target they want 50 records.how
can achieve this
No Answer is Posted For this Question
Be the First to Post Answer
What are system variables and sequencers in datastage
how can we create tables 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 some prerequisites for datastage?
how can u find out the datastage job is running on how many nodes
what is ds administrator used for?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
How can remove duplicates in a file using UNIX?
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
What is difference between server jobs & parallel jobs?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
Describe routines in datastage? Enlist various types of routines.