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 is datastage engine?

0 Answers  


what is a force compile

2 Answers   Cap Gemini, IBM,


i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,


What are the partitioning techniques available in link partitioner?

0 Answers  


how to load meta data

2 Answers   IBM,






hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,


Why do we use exception activity in Datastage?

0 Answers  


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers  


What are the primary usages of datastage tool?

0 Answers  


What is the difference between Link collector and Funnel Stages?

1 Answers  


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,


how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,


Categories