source contains 2 columns comes to target 4 columns how
Answer / fayaz
by using copyfile we can easily create 4 columns in targetfile.
| Is This Answer Correct ? | 2 Yes | 0 No |
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
Can you explain tagbatch restructure operator?
how to delete one row in target dataset
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
Differentiate between odbc and drs stage?
plz tell me some dimentional and fact table names in banking project?
How the ipc stage work?
What is the sortmerge collector?
what are the errors,warnings in datastage
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.