Source flat file contains
src
---
1
2
'
'
'
18
we had 3 targets
T1 T2 T3
-- -- --
1 4 7
2 5 8
3 6 9
10 13 16
11 14 17
12 15 18

How can i get?
**Using only datastage, but not unix or any other.
I am expecting the answer soon..
Thanks in advance.

Answer Posted / dinesh

Find MOD9 based on input data say we call as MOD

constraint in transformer

Target 1 - MOD IN 1,2,3
Target 2 - MOD IN 4,5,6
Target 3 - MOD in 7,8,0

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you start developing a datastage project?

746


What is the difference between server job and parallel jobs?

790


How you Implemented SCD Type 1 & Type 2 in your project?

3787


What are routines in datastage?

919


What is the difference between datastage and datastage tx?

692






client know skid info?

1724


What are the different layers in the information server architecture?

730


What is ibm datastage?

672


What are the differences between datastage and informatica?

680


To see hidden files in LINIX?

1031


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

663


project Steps,hits, Project level HArd things,Solved methods?

1707


What are the different type of jobs in datastage?

714


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

1873


How to manage date conversion in Datastage?

724