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?

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


Please Help Members By Posting Answers For Below Questions

Can you implement SCD2 using join, transformer and funnel stage?

1099


what is repositery?

1307


What are the various kinds of containers available in datastage?

581


What is datastage?

656


How many Key we can define in remove duplicate stage?

832






What steps should be taken to improve Datastage jobs?

652


Difference between ‘validated ok’ and ‘compiled’ in data stage?

687


What are the different kinds of views available in a datastage director?

611


How to clean the datastage repository?

708


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

1639


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3282


What are the features of datastage flow designer?

648


What are the main differences you have observed between 7.x and 8.x version of datastage?

633


What are the types of hashed files in data stage

658


I have a few records just I want to store data in to targets cycling way how?

1909