Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - My source seq file have col1 1 2 3 4 5 6 7 8 9 I have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?




586
views
asked mar September 20, 2014 06:31 AM  

My source seq file have col1 1 2 3 4 5 6 7 8 9 I have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?


           

1 Answers



 
answered By vishnoiprem   0  

As we will achive this as :

Order is seqfile->columngenerator->tfx->connect 4 targets. in CG take one more column as SNO(anything)and goto extended column properties- take value=1,value=2,,,upto 4. Now write constraint in tfx sno=1 goto t1 sno=2 goto t2... for all targets(4)

flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  1 person following this tag

  Question tags

datastage × 4

Asked 2 years and 3 months ago ago
Number of Views -586
Number of Answers -1
Last updated
3 years and 2 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert