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?
- 15 Answers
- 33354 Views
- Scope International, I also Faced
- E-Mail Answers
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 is ibm datastage flow designer?
describe the Steps to confiure a Qlogic switch
What is the difference between Datastage 7.5 and 7.0?
How many Key we can define in remove duplicate stage?
in oracle target stage when we use load option and when we use upsert option?
What is the difference between datastage and informatica?
What could be a data source system?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Differentiate between hash file and sequential file?
Explain the importance of surrogate key in data warehousing?
what are the errors,warnings in datastage
Name the different sorting methods in datastage.
How do you register plug-ins?
What are stage variables, derivations and constants?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
