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

Using transformer we have a system variable @INROWNUM which
will store the row number of each of the incoming row.
Using this variable in constrants part of the each link we
can split the records.

for more info mail me @ akellapavankumar@gamil.com

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do you need stage variables?

919


Define orabulk and bcp stages?

902


What are the types of containers in datastage?

931


What are the different options associated with dsjob command?

1195


which r the connectors used in san?

1979


Where the datastage stored his repository?

798


How to perform incremental load in datastage?

909


What is the difference between Datastage 7.5 and 7.0?

878


Can you explain engine tier in information server?

880


How a source file is populated?

832


What is quality stage?

769


How do u convert the columns to rows in datastage?

899


What is a merge?

859


What are the features of datastage flow designer?

829


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1867