Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is datastage engine?

1225


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

1063


What are the difference types of stages?

1287


What is staging variable?

1153


What are the important features of datastage?

1200


What are the various kinds of containers available in datastage?

1101


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5193


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1277


Describe routines in datastage? Enlist various types of routines.

1054


What are the benefits of datastage?

1301


What is data partitioning?

1269


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2933


How complex jobs are implemented in datstage to improve performance?

1096


What are stage variables, derivations and constants?

1283


what is the custome stage in datastage? how can we impliment that one? plz tell me

2410