Find MOD9 based on input data say we call as MOD constraint in transform

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.

Question Posted / dinesh

7 Answers
10504 Views
I also Faced
E-Mail Answers

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

What are the steps needed to create a simple basic datastage job?

1213

What is the difference between the local container and shared container?

1082

Explain ibm infosphere information server and highlight its main features?

1079

What are the functionalities of link collector?

1068

what is flow of project?

1979

How a routine is called in datastage job?

1080

What is meta stage?

1167

what is the use of materialized view?

1550

Define Job control?

1118

What are the stages in datastage?

1075

How do you remove duplicate values in datastage?

1135

What are the components of ascential data stage?

1165

Describe routines in datastage? Enlist various types of routines.

993

What are some different alternative commands associated with "dsjob"?

1138

What is the different type of jobs in datastage?

950