DSXchange

I faced the issue mentioned above in the input stages which I could resolve using the hash file. The same error now pops up in the ouput stage too :( I designed 2 jobs The first design, the transformer stage and the sql query is as follows : figure 1 ---> http://img113.imageshack.us/my.php?image=dsj...

Hi,

I redesigned the job as in figure :

http://img176.imageshack.us/my.php?image=dsjobbp0.jpg

Its working fine now.

Thankyou All
Athira

Hi,

The job in the figure raises the fatal error
ORA1..Package3_2: ORA-01036: illegal variable name/number

http://img161.imageshack.us/my.php?image=dsjobhl3.jpg

Did confirm with the user-defined SQL statement and the data in the table can be viewed. Please do comment on the same.

Thanks Athira

Hi, Even though the performance is not laudable, there has been an improvement from the no response status. When I checked with the Oracle database it was found that there was a lock due to an insert statement on the output table. I did kill some threads manually. http://img224.imageshack.us/my.php?...

http://img90.imageshack.us/my.php?image=dsjob3tv3.jpg http://img147.imageshack.us/my.php?image=dstransss0.jpg The SQL queries used in the 3 stages are as follows : (a user defined query) SELECT PACKAGE3.CMS_ORDER.ORDERID, PACKAGE3.CMS_ORDER.NINO, PACKAGE3.CMS_ORDER.ORDERED, PACKAGE3.CMS_ORDER.ORDSTA...

Hi, The lookup queries are generated. I tried using the Hashed File, still no response. http://img90.imageshack.us/my.php?image=dsjob3tv3.jpg http://img168.imageshack.us/my.php?image=dsjob4vh6.jpg As seen in the log should anyting be done with NLS settings. This job (without the hash files implement...

Hi,

The three ODBC stages as mentioned connects to 3 different tables in an Oracle database and the output is given to a table in a different Oracle database.
I waited for almost 8 hours