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
What are the types of hashed files in data stage
How do you start developing a datastage project?
What are the types of jobs we have in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the types of containers in datastage?
What is the project in datastage?
Enlist various types of routines in datastage.
Whats difference betweeen operational data stage (ods) and data warehouse?
how can we create rank using datastage?what is the meaning of rank?
What are some different alternative commands associated with "dsjob"?
Can you filter data in hashed file?
What are the repository tables in datastage?
How do y read Sequential file from job control?
What are routines in datastage?
Differentiate between operational datastage (ods) and data warehouse?