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

Hi I am Vijay
In my source i've 10 records in a single column.... but i
want to split those records into 5 sequential files each
seq file contains 2 records.?.... can any body help me?

Answer Posted / nukaraju andala

Hi iam nukaraju,

useing tranformer stage after source can get result.

trf_stage--->in system veriables having @inrownum useing
this

@inrownum=2 in constraint of target1
@inrownum<=4 - @inrownum<=2 in constnt target2
6 - " 4 target3
8 - " 6 target4
@inrownum>10 " target5

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of views in datastage director?

1776


what is 'reconsideration error' and how can i respond to this error and how to debug this

2633


What are the various kinds of the hash file?

1152


What is process model?

1984


Difference between data warehousing and olap?

1097


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3167


How to convert RGB Value to Hexadecimal values in datastage?

4000


I have a few records just I want to store data in to targets cycling way how?

2369


What are the various kinds of containers available in datastage?

1048


Which algorithm you used for your hashfile?

1186


what is the use of skid in reporting?

2381


On which Dimension Table you implemented SCD Type in your Project

2053


What is a ds designer?

1070


Differentiate between datastage and informatica?

1186


Can you explain how could anyone drop the index before loading the data in target in datastage?

1504