Interested to Buy Any Domain ? << Click Here >> for more details...
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....
- 4 Answers
- 8080 Views
- I also Faced
- E-Mail Answers
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
Explain usage analysis in datastage?
On which interface you will be working as a developer?
What is "fatal error/rdbms code 3996" error?
What is job control?
how can we create rank using datastage?what is the meaning of rank?
On which Dimension Table you implemented SCD Type in your Project
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are the functionalities of link partitioner and link collector?
How the ipc stage work?
Define Job control?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Why we use surrogate key?
what is flow of project?
What is the difference between validated and compiled in the datastage?
Describe routines in datastage? Enlist various types of routines.
