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

What is the purpose of pivot stage and types of containers in datastage

609


Different ways a project can be moved to production ?...example ….export-import and Version control.

1927


What a datastage macro?

631


explain about citrix scheduling tool in datastage

1808


Differentiate between hash file and sequential file?

576






Define Job control?

675


Demonstrate experience in maintaining quality process standards?

1923


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2698


How can you write parallel routines in datastage PX?

614


What are the main differences you have observed between 7.x and 8.x version of datastage?

618


How many types of sorting methods are available in datastage?

627


What is the method of removing duplicates, without the remove duplicate stage?

579


What are routines in datastage?

770


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2539


Difference between in process and inter process?

692