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 / abd

We can use stage variable in Tran Stage

IF @INROWNUM MOD 4 = 0 then T4
Else If @INROWNUM MOD 4 = 1 then T1
Else If @INROWNUM MOD 4 = 2 then T2
Else If @INROWNUM MOD 4 = 3 then T3

Try this

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use exception activity in Datastage?

1324


how can we create rank using datastage?what is the meaning of rank?

8802


Which algorithm you used for your hashfile?

1191


What all the types of jobs you developed?

1186


What is "fatal error/rdbms code 3996" error?

1278


Define meta stage?

1211


What is the purpose of pivot stage?

1180


Terminate Activity

1287


what is flow of project?

2009


What is use Array size in datastage

1788


How to implement complex jobs in data stage?

1121


What are the different layers in the information server architecture?

1137


Describe link sort?

1019


If you want to use the same piece of code in different jobs, how will you achieve it?

1166


On which Dimension Table you implemented SCD Type in your Project

2062