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...

my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?

Answer Posted / venkatesh

the flow is like this

source---->transformer-------->t1
----------->t2
-------------->t3
------------------>t4
in transformer create a stage variable to calculate mod value

mod(input,4) | mod_value
_________________|____________

in constrain write the condition as

mod_value =1 for t1
mod_value=2 for t2
mod_value=3 for t3
mod_value=0 for t4

try this u will get the required o/p

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is usage analysis in datastage?

1310


What are the functionalities of link partitioner and link collector?

1009


What is the difference between validated and compiled in the datastage?

1293


Where do you see different stages in the designer?

1094


What are the different layers in the information server architecture?

1128


Explain the importance of surrogate key in data warehousing?

1192


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

1106


What is the process of killing a job in datastage?

1020


Differentiate between odbc and drs stage?

1050


What are the main features of datastage?

1285


What are the important features of datastage?

1127


What are stage variables and constants?

1149


how to abort the job its matain duplicates?

2574


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2113


How can we improve the performance in datastage?

1105