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 |
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Why do you need stage variables?
what is time dimension? and how to populate time demension
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
What is the function in Transformer stage can act as Rank Function in oracle
how to add a new records into source?
Distinguish between informatica & datastage. Which one would you choose and why?
How do u convert the columns to rows in datastage?
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
What are the various kinds of the hash file?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?