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



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 ..

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

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 ..

Answer / mcssrinivas009

using random partiopn

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More Data Stage Interview Questions

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,


Why do you need stage variables?

0 Answers  


what is time dimension? and how to populate time demension

2 Answers   TCS,


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,


Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,






What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,


how to add a new records into source?

0 Answers  


Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  


How do u convert the columns to rows in datastage?

0 Answers  


CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,


What are the various kinds of the hash file?

0 Answers  


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 ?

4 Answers   HCL,


Categories