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
- 7720 Views
- I also Faced
- E-Mail Answers
Answer Posted / mrvprasad
Take 4 field names(field1 field2 field3 field4) in output stage.
use Transformer stage: In Derivation use the below substring
Field1: SourceColumn[1,5]
Field2: SourceColumn[6,10]
Field3: SourceColumn[11,15]
Field4: SourceColumn[16,20] use this one u will get correct o/p.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
whom do you report?
Lookup constraints
How to reverse the string using unix?
How rejected rows are managed in datastage?
What are the different common services in datastage?
What are the benefits of datastage?
describe the Steps to confiure a Qlogic switch
How can you write parallel routines in datastage PX?
How to implement complex jobs in data stage?
What are the different types of lookups in datastage?
why do u need the IOS upgradation in a FC switch
How many types of views are there in a datastage director?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
EXPLAIN SCD
Define Job control?
