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
Can you explain tagbatch restructure operator?
how to delete one row in target dataset
Differentiate between validated and Compiled in the Datastage?
What is the difference between informatica and datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How one source columns or rows to be loaded in to two different tables?
Can you explain how could anyone drop the index before loading the data in target in datastage?
which r the connectors used in san?
On which interface you will be working as a developer?
What are the functionalities of link partitioner and link collector?
What are orabulk and bcp stages?
How a server job can be converted to a parallel job?
What is a ds designer?
What are the steps required to kill the job in Datastage?
Highlight the main features of datastage?