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
- 33396 Views
- Scope International, I also Faced
- E-Mail Answers
Answer Posted / pakkya
declare stage variable in transformer, increment variable
with every row read. have 5 outputs from transformer with
constraint to write rows 1,2...3,4...5,6...7,8...9,10
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Is possible to create skid in dim,fact tables?
State the difference between an operational datastage and a data warehouse?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Explain the situation where you have applied SCD in your project?
What is merge stage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are transforms and what is the differenece between routines and transforms?
How to clean the datastage repository?
What all the types of jobs you developed?
Define Job control?
Define Data Stage?
What is difference between symmetric multiprocessing and massive parallel processing?
How one source columns or rows to be loaded in to two different tables?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
