Hi all,
Can you please let me know the syntax for converting date from mmddyy to mmddyyyy format in Transformer. Thanks!!
Search found 33 matches
- Wed Sep 09, 2009 6:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Conversion from mmddyy to mmddyyyy format
- Replies: 1
- Views: 1109
- Wed Sep 09, 2009 2:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help needed with job design
- Replies: 4
- Views: 1500
Arndw, sorry for the confusion. The lookup altogether is against a different file based on key columns common to both headers and details. I need to do transformations separately on all headers (header1, header2.....) and all details (detail1.1,detail1.2..........) and load them to target in the sam...
- Wed Sep 09, 2009 1:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help needed with job design
- Replies: 4
- Views: 1500
Help needed with job design
Hi all, Newbie here. Can you guys please help me out with a job design. Here are the details. I have a fixed length file containing a lot of headers(journal) and details(journal). The header records are distinguished from the detail by a column( Has 'A' for header, blank for detail). I have to do a ...