Search found 13 matches
- Thu Jul 28, 2016 12:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maximim file size that CFF stage can handle
- Replies: 3
- Views: 3282
- Wed Jul 27, 2016 12:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maximim file size that CFF stage can handle
- Replies: 3
- Views: 3282
Maximim file size that CFF stage can handle
Hi
What is the maximum file size that complex flat file size can handle?
we are expecting an EBCDIC file with 100 columns and the expected data volume is 100,000 records per day. Can CFF stage handle this?
Thank you
What is the maximum file size that complex flat file size can handle?
we are expecting an EBCDIC file with 100 columns and the expected data volume is 100,000 records per day. Can CFF stage handle this?
Thank you
- Tue Jul 26, 2016 12:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding comma's to an amount field
- Replies: 10
- Views: 5496
- Mon Jul 25, 2016 4:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding comma's to an amount field
- Replies: 10
- Views: 5496
Hi ArndW, Yes, we need to represent data in 'lakh' format. Agreed with you we can't store comma separators in numeric field. Right now my project requirements are not clear, we have got very high level details of transformations that we might need to apply on the input data, this is one among them. ...
- Mon Jul 25, 2016 12:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding comma's to an amount field
- Replies: 10
- Views: 5496
Adding comma's to an amount field
Hi
I have a requirement to add comma's to an amount field. Please suggest how to do this.
Source: Sequential file
Target: DB2 table
Example:
-------------
Input: 10000000000
Expected output: 10,00,00,00,000
Thank you
I have a requirement to add comma's to an amount field. Please suggest how to do this.
Source: Sequential file
Target: DB2 table
Example:
-------------
Input: 10000000000
Expected output: 10,00,00,00,000
Thank you
- Tue Jul 22, 2014 10:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scenario: Identify duplicated in a column
- Replies: 6
- Views: 4900
- Tue Jul 22, 2014 9:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scenario: Identify duplicated in a column
- Replies: 6
- Views: 4900
- Tue Jul 22, 2014 4:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scenario: Identify duplicated in a column
- Replies: 6
- Views: 4900
Scenario: Identify duplicated in a column
Hi, I have a scenario in my project, in a column there are two values separated by comma as shown below. Input ----------- AUS,IND AUS,PAK IND,AUS IND,PAK PAK,AUS PAK,IND If you observe in the above data, there a combinations of "AUS,IND" and "IND,AUS". In this case I have to con...
- Wed Jun 04, 2014 5:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SMP to MPP datastage code migration
- Replies: 1
- Views: 2098
SMP to MPP datastage code migration
Hi, we did our development in SMP system and now we have to migrate code from DEV to SIT. The thing here is our development server on SMP and SIT is on MPP. So I need to know about the things that we need to take care while migration code from SMP to MPP. One thing we got to know while running the j...
- Fri Mar 07, 2014 1:27 am
- Forum: General
- Topic: Surrogate key generation
- Replies: 1
- Views: 1400
Surrogate key generation
Hi, I have a scenario to generate surrogate key in an audit table which has the below columns. Audit Table ----------------- Surrogate_key job_name job_status, start time end time At the beginning of each sequence I have to insert a record in the audit table with values in columns surrogate_key, job...
- Mon Jan 13, 2014 12:40 am
- Forum: General
- Topic: Export: Export job executables without design
- Replies: 1
- Views: 1626
Export: Export job executables without design
Hi, I have some doubt regarding the job export options. There is an option 'Export job executables without design'. Dose this option exports only executables without actual job design and in which cases can we use this? I have tried to test this functionality by export a job with this option, but wh...
- Fri Nov 29, 2013 1:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to pass data value to next PX job parameter?
- Replies: 7
- Views: 4034
- Fri Oct 25, 2013 2:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculating Valid_To date based on input date
- Replies: 1
- Views: 1494
Calculating Valid_To date based on input date
Hi, I have a requirement like from source I am getting valid from date for which I have to calculate valid to date. The data is actually about currency exchange rate. I will data in a file and it is a monthly file, it will have four columns which are given below. from_currency to_currency valid_from...