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
root tree will find which is server job and which is parallel job?
How to manage date conversion in Datastage?
What are the important features of datastage?
Explain connectivity between datastage with datasources?
AGGREGATOR default datatype
What is the difference between server job and parallel jobs?
How the ipc stage work?
How you can fix the truncated data error in datastage?
What are the functionalities of link partitioner?
Differentiate between validated and Compiled in the Datastage?
On which interface you will be working as a developer?
What are the main features of datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How many types of hash files are there?
What are the differences between datastage and informatica?