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 |
Differentiate between Join, Merge and Lookup stage?
What is "fatal error/rdbms code 3996" error?
Triggers,VIEW,Procedures
how many stages are there in Datastage... Please clarify mee??
what is the function in Transformer stage can act as Rank function in Oracle
Explain the situation where you have applied SCD in your project?
i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com
How can u write exception handling in seq file????
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
What is the function in Transformer stage can act as Rank Function in oracle
How to create a doccument in datastage?