Source file and 3 output tables records problem

Suppose i am having a source file and 3 output tables and I want first row to be written to first table second row to second table, third row to third table likewise how can we achieve this using datastage without using partitioning?

Questions by taruna.arya

Showing Answers 1 - 9 of 9 Answers

Vikram Singh

  • Nov 11th, 2014
 

Can we use loop here?

  Was this answer useful?  Yes

Pratheeksha

  • Nov 12th, 2014
 

For this, one option could be :
Get the row number column from the source seq file, in the transformer use stage variable which is defined as below:

if mod(i/p col,3)=0 then
if mod(i/p col,2)=0 then
"2"
else
"3"
else "1"

  Was this answer useful?  Yes

Dheerendra

  • Nov 14th, 2014
 

Use SEQ---> Transformer stage ----> 3 SEQ Files In transformer stage add constraints as Mod(@INROWNUM,3) =1, Mod(@INROWNUM,3) =2, Mod(@INROWNUM,3) =0

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions