DSXchange

We also had the similar scenario in our project. We observed that using user defined SQL is efficient instead of using multiple stages in a job. we had a SQL having 17 joins & all joins were used in a single OE Stage. it works. But if you need to apply some logic after the data sourcing/Joining,...

have a look at this post for more details.
viewtopic.php?t=124275

Please post the Job design. So that one can find the options in the stages used in job or can suggest a new o be included.
You can rectify it by using trimB() to trim spaces in transformer.

check in ODBC admin for available ODBC drivers installed

You need to explicitly Install ODBC pack for different DBs. For Eg: MS Excel, Oracle, Teradata etc.

If you want to Extract n char from a string, go for Left or Right Functions.
Left(string,Number).

I don't think its quite possible through Filter Stage. Becuase, In Where parameter, You need to specify operators =, like, between. So use a transformer. Use the derivation to filter after converting the I/p column to Lower or Upper Case. output_link.col_b --->> lower(input_link.col_b)='pink' This a...

Please mark the Post as resolved

There can be n number of issues. The presumed one may be not the actula. Hence,could u please post the OSH code generated. It gives more clear picture of the operations that intend tio be performed by the job.

Please be clear with the requirements. Whether the the job should write whether only duplicates or all records if encountered with duplicates. In PX , the Job can be designed like, the one below, 1.if you want to filter out only duplicate records. seq_file_stage ---->>agg(no. of rec with a key)---->...

Thanks everybody for the Technical guidance.
The issue isn't resolved yet, but hope it soon due to diligence efforts by the members of this forum.

Although not complete resolution, but narrowing down the possibilty of cause gave me a good knowledge of the basics required.

Thanks Folks,

Thanks ArndW. I can't see your suggestions after third line. I set APT_ORA_WRITE_FILES =' (DIRECT=TRUE, PARALLEL=FALSE) ' Inspired by the success of Oraupsert , I tried Upsert on a table using a sort Stage whose Output is 918553 records. Now the same Porblem of hang is reproduced. Does DS use sqlllo...

The job hangs only when I try to Load Oracle.
But i succeeds when i do an Upsert/insert.

I need to configure sqlloader????

lstsaur wrote:Did you mean you were able to insert or update table using SQL*Plus?

Yep. I did i.

ArndW wrote:the full outout above is too much for me. Are you doing a load or normal table writes? Can you actually do an insert or update manually to this table? ...

Yep. I did it successfully.