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

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1215


How can you write parallel routines in datastage PX?

1015


What are the primary usages of datastage tool?

1075


What are routines in datastage? Enlist various types of routines.

1101


What is the purpose of pivot stage?

1168


Why do we use link partitioner and link collector in datastage?

1137


What are the partitioning techniques available in link partitioner?

2279


What is the difference between in process and inter process?

1147


What are some prerequisites for datastage?

1098


Differentiate between hash file and sequential file?

1072


What is ibm datastage flow designer?

1149


What is quality stage?

987


Can you implement SCD2 using join, transformer and funnel stage?

1557


options available in sequence job to run,validate?

1317


What are the components of ascential data stage?

1189