DSXchange

Hi, The following message is found in the log. ORCL_TGT_Supplier,0: Records inserted: 3,281 (........) Once I click on this line I am able to see ORCL_TGT_Supplier,0: Records inserted: 3,281 Records used for update: 100 Records rejected: 0 Total records: 3381. So to see the record count that got upd...

Hi, When I run a job, the log shows the number of rows inserted into the table concatenated by brackets. If I click on the log it is showing the number of records too. Earlier it used to show the number of records inserted and records updated directly in the log. Is there any parameter that we need ...

Hi,
How to Handle the nulls on date fields using Handle_Null in modify stage.

I tried

Run_date = Handle_Null(Run_Date,'')
and
Run_date = Handle_Null(Run_Date,'0')

But the job is getting aborted due to this.

Thanks,
Phani

Hi,
I am using PX on 2 node config.
how many reference links does the lookup stage can accept.

I have to check for 45 lookups.

Is there any constraint on the number of reference links to the lookup stage.

Thanks,
Phani

Hi, Thanks for the inputs. I am capturing the row count at the link level. But, I want to capture the number of records getting updated / inserted through the oracle enterprise stage using the UPSERT command. Infact I am able to capture them by reading the log and capturing the occurrences of the in...

Hi, I want to capture the number of records that are getting updated / inserted into the database. I am capturing the job statistics using a routine. Oneway to capture the record count is through reading the log file and get the statistics. Is there any function so that I can get the rowcount direct...

Hi Ray, Please refer the parallel job advanced developer guide , page number 7-103. It says that Result = DSGetStageLinks(JobName, StageName, Key) results in giving the links linked to the stage Key stands from 1 and 0 where 1 stands for input and 0 for output. But this is not dimensioned. Thanks, P...

Thanks Ray. In the doc, I came across the DSGetStageLinks Function. But it was not dimensioned in the JOBCONTROL.H.So I was unable to use that. Infact , I came with a similar solution but did not include LinkType = Field("Input|Output|Reference|Reject", "|", Field(LinkType, "...

Hi, I am using DSGetStageInfo for capturing the LinkTypes. It is returning 1 , 3 as values. I want to use DSGetStageLinks to capture the link information ( Input Link of the stage , output link of a stage). When I try to use this function , I am getting an error as DSGetStageLinks never dimensioned....

Hi,
How to access the VSAM Files from the Mainframe server.
Do we have any Plug in for mainframe - VSAM like SAP plug in to access from Unix box.
If so, where can I get the information regarding that.

Thanks for the response.

Phani

Thanks for the info.
It worked fine.


Thanks,
Phani

In this job, I am extracting data from the oracle table, doing lookup against some tables doing some aggregations and loading to the final output to the target table and as well to the Lookup file set. Everything is going on smoothly.But at the time of loading the data I am getting this error. --Phani

Hi , When I am loading the Look up file set, the below warning is appearing constantly. Operator of type "APT_LUTCreateOp": Will partition despite preserve-partitioning flag on dataset on input port 0 The partition type used is "Entire". What could be the reason and how to resolv...

Hi,
It seems some char data is getting passed into a field having numeric as data type. Try to use NullToZero tranform to eliminate this error.

IHTH,
Phani

Hi,
Use NulltoEmpty tranform while concatenating the fields.
It will work.

Ex
NulltoEmpty(Field1):NullToEmpty(Field2):NullToEmpty(Field3):NulltoEmpty(Field4).

Phani