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
What are the types of views in datastage director?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the various kinds of the hash file?
What is process model?
Difference between data warehousing and olap?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How to convert RGB Value to Hexadecimal values in datastage?
I have a few records just I want to store data in to targets cycling way how?
What are the various kinds of containers available in datastage?
Which algorithm you used for your hashfile?
what is the use of skid in reporting?
On which Dimension Table you implemented SCD Type in your Project
What is a ds designer?
Differentiate between datastage and informatica?
Can you explain how could anyone drop the index before loading the data in target in datastage?