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
- 32877 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 data partitioning?
How many types of hash files are there?
Highlight the main features of datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Define Routines and their types?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Explain how a source file is populated?
How to RD using transformer?
How can one find bugs in job sequence?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Explain the situation where you have applied SCD in your project?
What are stage variables and constants?
Which warehouse using in your datawarehouse
how to abort the job its matain duplicates?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
