Hi,
I am having 6 million of records in the source file.
Which one (DELIMITED OR FIXED WIDTH) is better to use as a source?
Can you please provide me some insight(advanatages & disadvantages) regarding this?
thanks and regards,
MCH
Search found 32 matches
- Thu Dec 20, 2007 10:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delimited v/s Fixed width files
- Replies: 1
- Views: 951
- Wed Oct 24, 2007 3:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can any one look into this????
- Replies: 13
- Views: 4569
I hope the following are true- INVOICE_NO column is unique in Payment_Details CUSTOMER_ID column is unique in prepaid_sales USE ONLY ONE ORACLE STAGE, In user defined query, put this sql statment select A.INVOICE_DATE, A.INVOICE_from, A.INVOICE_to, A.PAYMENT_DUE_DATE, B.PAID_DATE, C.RECHARGE_DATE, C...