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
What is datastage engine?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the difference types of stages?
What is staging variable?
What are the important features of datastage?
What are the various kinds of containers available in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Describe routines in datastage? Enlist various types of routines.
What are the benefits of datastage?
What is data partitioning?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How complex jobs are implemented in datstage to improve performance?
What are stage variables, derivations and constants?
what is the custome stage in datastage? how can we impliment that one? plz tell me