in one scenario source flat file like
Fileld1
00122001550056200568
00256002360014500896
00123004560078900258
00147004560025800256
divide each 5 numbers as one column i.e
here i need
field1 field2 field3 field4
00122 00155 00562 00568
00256 00236 00145 00896
00123 00456 00789 00258
00147 00456 00258 00256
plz help me....
Answer Posted / sindhu
BY using sequential file in format delimeter =none while importing the data enable the option fixed width and give column width 5 space 5 space 5.datatype as varchar inorder to get zeros also in output.
reducing the stages will always increase performance
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In Datastage, how you can fix the truncated data error?
What is the difference between the local container and shared container?
How can we improve performance of data stage jobs?
Define data aggregation?
How many types of sorting methods are available in datastage?
how can we create rank using datastage?what is the meaning of rank?
What is a quality stage in datastage tool?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Can you define merge?
How do you import and export data into datastage?
Can we use target hash file as a lookup ?
Describe stream connector?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are datastage sequences?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?