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 |
What are the environmental settings for data stage,while working on parellel jobs?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
On which interface you will be working as a developer?
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
What are the types of containers and how to create them?
How to clean the datastage repository?
Nls stands for what in datastage?
HOW CAN WE SEE THE DATA IN DATASET?
Define Routines and their types?
What modeling tool do you use?
What is PX?