DSXchange

Hi Srini,
We r also getting the same Lock Issue. Kindly let us know if you have got solution to this by now.

Thanks

Ray,
Kindly let us know if there is any round about way to handle Update and Insert in a single job.


Thanks

Ray,
Kindly let us know if there is any round about way to handle Update and Insert in a single job.


Thanks

Try to remove the Installation fully and re-install it again.In the previous installation you have probably ignored some warning messages. Also please do check the System date of your Machine, it might have a conflict with your License Date Ranges too, MAY BE

Thanks for the instruction, Rasi. But Can't we achieve this in a Single Job only.When we also do it in Two Jobs we get the perfect,but in a Single job it hangs. Could you please let us know why this happens and can't we achieve this in a single job only.

kduke wrote:You could use a constraint to start at @INPUTROW > StartRow where StartRow is a parameter. I am not sure if this works in PX.

Thanks Duke.We'r trying the same.

Hi All, We are developing a Job that will take care of SCD Type-2. First let me explain how we are implementing the same. 1.Data Extracted from Source using Teradata Access Plug-In 2.We then look up the Target table and basing upon the constraint and look up we Update or Insert the Target table in t...

Hi all,
Can anybody let me know how to generate Custom Log reports and perform File PURGE Procesing through Parallel extender. We need to purge the files that have been processed without any eeror and if the file is not processed properly then it should not be moved from the input directory.

Hi All, I am loading data from DB2 table to another DB2 table. I want to generate a report that will give me details of the load like: 1. Number of rows processed. 2.Start time and time Input number of rows. 3. Aggregated values of the Numeric fields processed. e.g. Total Sales in Dollars for all th...

Hi All, I am using Parallel Extender 7. I am extracting data from DB2 and the number of records is 5500000000 (550M). I am putting this data into DB2. Now my job aborts at 250M (250000000) the record. Now when doing a reload I want to start it from 2500000001 th record. Kindly let me know how to ach...

I have a sequential file as source and another sequential file as target. I want to capture the number of records of the source file in the target. Please lemme know how to achieve this.

Thanks
Bapajju

Thanks Bland:).I got a fair idea. A one row hash file should be a one row table every time for a reference lookup. A hash file is a local reference object on the server, a table suffers network overhead plus query preparation plus results fetch plus spool. A hash file can preload to memory making ev...

Hi, I tried a lookup using a hash-stage for 5000 records. The same lookup I tried through OraOCI stage and both of them effectively took the same time. But While tried the same sort of experiment with 4000000 records I found that Hash-Stage is far far faster than the OraOCI. Just wanted to know if ...

Thanks a ton Ray.It worked afer sorting.It was a memorry problem only.Appreciate your help.