DSXchange

Thanks chulett

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

Hi SURA,

Even I am not clear at this point of time what will be the target and its data type. I am guessing it could be varchar as numeric/decimal data types don't support this format.

Thank you

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. ...

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

Thank a lot Yugee, that works perfect.

But one small check, we can directly apply field function to seperate the string, instead why are you using Index and field?

Hi,
If I split and sort the data then it will look like below.

After applying split and sort
-------------------------------
AUS,AUS
AUS,AUS
IND,IND
IND,IND
PAK,PAK
PAK,PAK

This might not give expected result.

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...

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...

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...

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...

If you are running the two jobs in same sequence you can do it in this way.

Sequence : UservariableStage-->Job1-->Job2
In the user variable stage get the current timestamp first and then use it in both the jobs by passing as parameter.

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...