DSXchange

Is the double Thanks for my double post?

In the design, the Output hashed files are named as Line1_ INSTANCE, i.e All the 10 Instances are creating there individual Hashed files.... Not two instances of the job are writing into the same hashed file.... What is the performance Stats for the output link shows? Are they constant for all the ...

asitagrawal wrote:Hi All,
The Input has 8 key flds, but the reference has just 4...
so it is a match of only 4 key flds...not all 8..

In this case the CRC can be for those 4 column should be done on both input as well as the Instance Lookup.

By any chance are they loaded with spaces, might be due to some Null handling in Datastage.

But as per Kenneth, in the following post, post1 post2it seems its possible with 32 bit client. And ODBC doesn't require it.

Iam afraid not. Though the configuration that require in dsenv is the same, you can just give it a try by giving $DSHOME/./branded_odbc/lib.
The files that you will need to edit would be dsenv, .odbc.ini, uvodbc.config.

Hi Athira, Its time again for you to change something in this post when the solution is arrived.

DATE.TAG can also be used to find the Date component.

No, you should have standard Oracle client installation on the server.

Were you able to Import metadata using this connection?

Were you able to connect to Oracle database using this setup from command line?

Do you mean, you are trying to connect to remote database?

I too have seen this funny thing especially with the CALL. I dont exactly remember what I did to overcome that.
Just Try call SP_CID_EXTRACT_CUST_DATA_FIX1.

I ment to say JobActivity for each job and set of jobs in a JobSequence.

You can include RowNumberColumn in addition to FileNameColumn.