DSXchange

Hi Shalini,

Sequential file stage can also be used as output of change capture.
We havent tried Oracle Enterprise stage.

Just check the properties of Change capture stage.
If you have given Drop for Copy as True. And if all the records match, we will not have anything in output

Thanks VJ. This helped

Hi.. I have a requirement where I have to concatenate a date field and time field and send it to Timestamp field. How to achieve this? My thought was to convert both date and time into string and concatenate them and later convert from string to timestamp? Is this is the correct approach. I'm also n...

Examples are given in datastage itself. If you check the routines category in designer, there is something called as Examples\ Functions. There are 8 routines. Hope this helps

If you are validations with date, the initial date value passed to that column is incorrect. This is one of the reasons for the error

Check for this message in search "Failed to connect to JobMonApp on port 13403".

Also, check out this link. It might be of a help
[url]http://www-128.ibm.com/developerworks/f ... 8&tstart=0[/url]

We tried auto partition also. It didnt work. As this issue occurs only with huge data, we are not able to trace back to the root cause. We are still debugging the issue. Meanwhile, due to time constraint, planning to proceed with single node.

Hi Rajeev, I had the same scenario and it was done in after job routines using DSGetLinkInfo() function.

Thanks.

Thanks so much. Do you know where this new config file which we create in designer will be stored? In case if it gets created in unix, I just wanted to make sure that no other user deletes it.

Hi, Is there any parameter that can be defined at job level to make the job run on single node in multi-node (4 nodes) environment? We dont have access to change the Config file. Is there any other parameter available in datastaga? I'm facing issue with join stage which gives different output for ea...

Thanks Ray. As the feature was available in other ETL tool and as am new to datastage, was wondering if there is such thing in Datastage also. Thanks agian.

Hi.. I have the following scenario. In the source, I have a date field named VALID_D. In the reference DB2 table, I have the following columns CURRENT_DATE, FROM_DATE and TO_DATE. Primary key is CURRENT_DATE. We have entry for every day for 5 years. I have to check if the VALID_D from source is betw...

Hi Balaji.. It worked fine with single node. Re-creating the jobs to check if something has missed out. Is there any other method to find the issue?

Hi Amit,

I'm also facing similar issue. How did u use entire partitioning?

My target is a DB2 table. When I give entire partition in join, it gives primary key violation.

Going mad with this... Please help!