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
- 6463 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
Why do you need stage variables?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are stage variables and constants?
How we can covert server job to a parallel job?
Why do we use link partitioner and link collector in datastage?
Explain usage analysis in datastage?
Define meta stage?
Name the command line functions to import and export the DS jobs?
On which interface you will be working as a developer?
Can you explain players in datastage?
Lookup constraints
What is difference between symmetric multiprocessing and massive parallel processing?
How you Implemented SCD Type 1 & Type 2 in your project?
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)
What is the roundrobin collector?
