DSXchange

Be more specific about the arguments you used with Oconv() and Iconv(). Without that information it is impossible to provide any diagnosis. We also need the exact text of the error message that is t ... My source is: start_date varchar2 (10) (Format of data is:'12-may-07') My desired target is s st...

ray.wurlod wrote:Not in one job. You can only build the target table name dynamically by passing these values as job parameters, then constructing the table name from these, or by constructing the table name in the i ...

I am an amateur in datastage.
Can you help me how can I do the same??

Hi All, I have a target table Name as X_07A,X_07B,etc..... here: 07 is year A-Jan B-FEB, C-MAR & so on. I pass a recorddate:20070506 i.e(06-may-2007) by using this record date can I dynamically build the target table name?? Can i use DSGetParamInfo & if I can suggest how... Eagerly awaiting ...

At Source: I have a '13-may-07' value stored as string. After transformation ,I convert it to date as I have to load that data in to a table where that column datatype in the table is Date. If I use Oconv & Iconv then error message is thrown. But If i change the target datatype to timestamp afte...

What are the major roles of Datastage Manager??

what is the hashing algorithm used in HASH lookup???
What is the difference between static & dynamic hashing in Datastage??

1.There is a base table from which i extract data for the previous entire month and store it in a .dat file. 2.Then i take the entire data from the target table (which do not have prevoius month data) and again store it in a .dat file 3.Then i merge and aggregate these file. 4.Then i truncate the ta...

I have to extract data from a table that has summarized historical records of past 1 year. Then I merge and aggregate the data with current month's data. Then i truncate the table and load the merged data again. Is there a better way than doing this,as extracting the data takes more than 6 hours. Pl...