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
- 7719 Views
- I also Faced
- E-Mail Answers
Answer Posted / anat
Hi as per my knowledge pls follow the below steps
1)take entire source as single colom
2)in transfomer split that colom in to multiple coloms by
using substring or field functons
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How complex jobs are implemented in datstage to improve performance?
How many types of views are there in a datastage director?
How one source columns or rows to be loaded in to two different tables?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How to reverse the string using SQL?
Why fact table is in normal form?
Is possible to create skid in dim,fact tables?
What is the difference between account and directory options ?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is "fatal error/rdbms code 3996" error?
Can you explain players in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the different plug-ins stages used in your projects?
Explain how a source file is populated?
