5) A file contains 10 (1-10) I want trgt like
Trgt 1 trgt 2 trgt 3
1 2 3
4 5 6
7 8 9
10
Answers were Sorted based on User's Feedback
Answer / rambabubollineni
while that time we use transformer stage
in transformer stage we use function like mod(source
colname,3)=1 for first target.for2nd target we write
mod(s.col,3)=2,for3rd target mod(s.col,3)=0. fimally we get
results.
| Is This Answer Correct ? | 12 Yes | 1 No |
Different ways a project can be moved to production ?...example ….export-import and Version control.
on how many columns we can perform aggregation in the aggregator stage?
What is the process of killing a job in datastage?
What is ibm datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
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.
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Please tell me What is difference between 8.0 and 8.1
what is the main difference between sorragate key n primary key in one word
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)