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
- 32891 Views
- Scope International, I also Faced
- E-Mail Answers
Answer Posted / pavan
Using transformer we have a system variable @INROWNUM which
will store the row number of each of the incoming row.
Using this variable in constrants part of the each link we
can split the records.
for more info mail me @ akellapavankumar@gamil.com
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
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
How do u convert the columns to rows in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
How do you start developing a datastage project?
What is the difference between odbc and drs stage?
Explain entity, attribute and relationship in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Differentiate between datastage and informatica?
How many areas for files does datastage have?
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?
What are the components of datastage?
What is the command line function to import and export the ds jobs?
How to implement complex jobs in data stage?
How to perform incremental load in datastage?
