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
How we can covert server job to a parallel job?
Highlight the main features of datastage?
root tree will find which is server job and which is parallel job?
Which commands are used to import and export the datastage jobs?
Explain ibm infosphere information server and highlight its main features?
Define Merge?
Differentiate between Join, Merge and Lookup stage?
How many areas for files does datastage have?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What steps should be taken to improve Datastage jobs?
Differentiate between datastage and datastage tx?
Define oconv () and iconv () functions in datastage?
What is the difference between datastage and informatica?
What are the different kinds of views available in a datastage director?
how to implement scd2 in datastage 7.5 with lookup stage