DSXchange

Not sure abt ACG or any other utility. I found some information on DSXChange itself.

Hope this will help you -

viewtopic.php?p=344116&sid=248f6f3866e2 ... ef99c66446

Did you tried inserting the records from SQL command prompt. Check whether Oracle is loading these 2 records properly or not. Based on your explaination, it seems there is no problem with Oracle, as you are able to load the record in Server job. But, do check by inserting the record using Insert sta...

Informatica and Datastage are two different ETL tools.

There is no such method defined to migrate from One ETL tool to Other. You have to develop Datastage code from scratch.

Stage Variable - Scope limited to the stage, basically used to perform some sort of Calculation/Darivatives.

Constraints - Expression/Conditions which decide whether the records proceeds to particular Output link or not.

Use the below one -

If IsNull(Date_Column) then SetNull() Else StringToDate(Date_Column, format)

Yes. give brief about your problem summary, then only any one will be able to give you suggestion.

what kind of exception?? Question is not clear.

But, just to add-on, there is a Exception Handler stage available in DS Sequence. you can use that to catch the exception.

Could go with the work around suggested by Vinashi. I will go for sequential funnel by selecting Table 2 link as 1st link.

I am agree with Ray. Join is not permitted on NULL.

Alternatively, you can handle NULL before performing the join operation and assign some value say '-999999' and revert it back to NULL once you are done with your join operation.

Yes. You can unless you change the content of the dataset.

Hi, there are already replies available on the forum for your query.
Do search, before posting any of your query.


Hope this helps you -

viewtopic.php?t=131351&highlight=schema+file

specifically Windows 2003 Server.

We need more explaination about 'updated records from file'. Does this mean compare to existing record in file itself or in target database?

Hope this will help you to renew Datastage License -

viewtopic.php?t=129816&highlight=licence+license