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

what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,


how to handle null values using transformer stage?

1 Answers  


hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers   Polaris,


How you can fix the truncated data error in datastage?

0 Answers  


detail about sdlc

4 Answers  






How the ipc stage work?

0 Answers  


whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,


This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,


one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

8 Answers   IBM,


how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,


Highlight the main features of datastage?

0 Answers  


What are the unit test cases you used in your project?

1 Answers   CSC, HY,


Categories