Search found 49 matches

by ghostraider
Tue Jan 02, 2007 2:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Constraint and Reject
Replies: 7
Views: 2378

kcbland wrote:Are your dates formatted to YYYY-MM-DD? ...
No they are of MM-DD-YYYY format. thanks
by ghostraider
Tue Jan 02, 2007 2:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Constraint and Reject
Replies: 7
Views: 2378

Constraint and Reject

Hi, i am trying to write a constraint based on the following logic. The TERMINATION_DATE from RTL_MERCH_CONTRACT shud fall between the ACTUAL_OPEN_DATE and the ACTUAL_CLOSE_DATE of retail account. All the valid outputs are written to one file and the rejects have to be written to the error cycle for...
by ghostraider
Tue Dec 26, 2006 3:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Format
Replies: 5
Views: 1078

Date Format

Load ready file is just a flat file with the necessary tranformations made based on the requirement.

Thanks for the welcome message :D
by ghostraider
Tue Dec 26, 2006 3:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Format
Replies: 5
Views: 1078

Date Format

I am developing a load ready file for SAP BW. Can someone tell me what date format should the load ready file have?

Thanks