DSXchange

Hi
Suppose we have records like

zip,age,apt
48201,20,2
48201,20,1
77058,60,2
77058,20,2
48201,30,5
85674,35,90
77058,10,60
48201,60,30

If we partition the data using all three keys in order zip,age,apt on two nodes ,does all records with zip 48201 arrive on the same node always.

Thanks
Arif

Hi In one of my job , a transformer which checks the following null condition if ISNULL(RM_NULLS.COL1) And IsNotNull(RM_NULLS.COL2) then RM_NULLS.COL3= RM_NULLS.COL4 else RM_NULLS.COL3 for which I am getting warning APT_CombinedOperatorController,0: Field 'COL1' from input dataset '0' is NULL. Reco...

Hi In one of my job , a transformer which checks the following null condition if ISNULL(RM_NULLS.COL1) And IsNotNull(RM_NULLS.COL2) then RM_NULLS.COL3= RM_NULLS.COL4 else RM_NULLS.COL3 for which I am getting warning APT_CombinedOperatorController,0: Field 'COL1' from input dataset '0' is NULL. Recor...

Yes , what you can do is create a procedure to refresh the materialised view and call this procedure in the close command of your target stage in the job or call the procedure through datastage after the loading job finishes. Since your users will always be hitting the materialised view, they will ...

Or load a second copy of the table and when the load completes, swap it in for the original. :wink: Exactly, this is called mirroring. It is infact pretty easy to achieve this through materialised views. Maintain a materialised view for your table and make sure that users always hit the materialize...

Hi One of my jobs refreshes the datamart using ODBC enterprise stage's truncate and write option.The job runs for about 10 minutes during which the data gets deleted and loaded and user sees an inconsistent data. Is it any way possible to see the old data in the table during the run time ,and after ...

Hi I have three jobs which loads the data in oracle database.The jobs are simple with only two stage jobs ,the first stage extracts the data from sybase using sybase ocpx stage and loads it into database using ODBC enterprise stage ,I have set the array size to 10000 and isolation level to read comm...

I have never seen that error message before but i can certainly point you in the right direction. Lets start with analyzing the sql error. For that click here And try to investigate on the error and see why in your sql giving this kind of error. I just love google university :wink: The sql is prett...

Hi I am sorcing the data from sybase database using the Sybase OCPX stage and user defined sql. I got the following warnings Sybase_OC_0,0: Warning: CopyOf end_st .Sybase_OC_0: Sybase Server warning 2762 (severity 16) from stored procedure 'sp_tables', line 209: The 'CREATE TABLE' command is not all...

us1aslam1us wrote:Hi

what is the parameter5 in your job? Check that one..

Thanks
Sam

I dont know what does it mean by parameter 5 ,the job doesnt have any parameters

ray.wurlod wrote:Have you tried to declare a decimal(0) or string[0] or similar in the fifth field?

No the fifth feild is varchar (50)

Hi
Is it possible to get the records which are not inserted (or rejected) in the database while loading the data using ODBC stage with write option .
Thanks
ARif

Hi
When I use an Oracle OCI stage the job runs fine but when using ODBC stage with write option I get an error
Can somebody suggest me what is this error APT_CombinedOperatorController,0: [DataDirect][ODBC Oracle driver]Invalid precision value. Error in parameter 5.
Thanks
Arif

Have you even tried to create a Rejects link? Let us know the result. I doesnt accept any reject links ,even the ODBC enterprise stage with the property truncate and write doesnt supports reject links. Is there a way to capture records that are not inserted in databse to a sequential file . Thanks ...

Hi
Is it possible to give a reject link to DRS stage while doing truncate and insert,so that all the records not inserted goes to a sequential file .
Thanks for help
Arif