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
- 33370 Views
- Scope International, I also Faced
- E-Mail Answers
Answer Posted / venubabu
Mr vijay
First by using pivot stage 10 records in single column
convert into 10 rows,
Next by using transformer stage send two records to one out
put.similarlly for remaining out puts.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to reverse the string using SQL?
What is the command line function to import and export the ds jobs?
How rejected rows are managed in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Explain datastage architecture?
why do u need the IOS upgradation in a FC switch
How to RD using transformer?
What are the enhancements made in datastage 7.5 compare with 7.0?
How do you register plug-ins?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How do u convert the columns to rows in datastage?
