DSXchange

Seems pretty straightforward, therefore I'm not sure I understand the problem. If all the good records are committed when the commit level is 1 and some good records are being dropped when the commit level is set to a number higher than 1 then isn't it obvious that when a rollback occurs when a bad...

Hi , I have a source ora stage & a lookup of hash file & writing output into a hash again , my source is have millions of record but out of tht i just wanna pick 100 of rec which are present in hash lookup ,prolem is tht even after writing that 100 rec into target it keeps on searching of th...

benny.lbs wrote:It seems his requirement not only to change the nullability, but also want to set NULL.

ray.wurlod wrote:What about simply targetfield:nullable integer=sourcefield ? ...

Yes I want to set the field to Null if its ''.

Hi, My mistake. Source is Non-Nullable and Target is Nullable. In the join stage if the join is outer and if the condition fails then the fields which are non nullable will have '' values. In the target, if such values are nullable i want to assign Null to these fields. eg If field1 = '' then SetNul...

Hi, I have a non nullable field in source. But in target this field is non nullable. I want to make it non nullable using modify stage. Currently this is achieved using transformer stage. Also if the value of the field in source is '' then i want to set it to null in target. I could find nullable to...

Hi,
we are getting problems with oracle 8 & 9 plugins.
it was working successfully before.

Hi,
I am getting problem while importing plugin meta data

its throwing error 'Unable to initialize plug-in:'

How to resolve this error.


thanks in advance.

Thanks ArndW.

There is a mismatch between number of columns. But the number of columns are more in the target table. The source file has less number of columns.
Can this also create problem in case of Sql Loader ?

PLease help.
Thanks in advance.

Hi,

I have one parallel job which loads data into oracle table from a dataset using sql loader.
This job is failing and the error I am getting is "Fatal Error: Pos arg exceeds numFields()-1: 30".

Anyone knows what can be the reason.
Please help.
Thanks in advance.

In the job we are creating a file of rejected records for different condition & using different lookups. in first mode in which we are creating file (overwrite mode) we are getting one record coz its only one record matches reject condition. In second write (append file mode) we are writing anot...

Hi, its a strange kind of error i am facing . the job is running fine in developement environment but giving problem in test env. Inserting data into seqfile first in overwrite mode then in append mode overwrite mode write one record in file append mode write say 1000 redcord in same file in between...

yes its windows XP sp 2

HI ,
i not able too see properties of job activity & routine activity.
whenever i click on that nothing comes.


note: it with all the enviroments (dev, uat , prod)

on different server so think its not server or project specific.


Thanks in advance
Parwaz

Hi Their a start loop activity & end Loop activity in datastage Make use of that in sequence & put your job which loads the file in between that loop In the property of start loop specify loop type as numeric & in loop definition specify in from 1 step 1 to 10. this will run ur file load...

There is an option in properties of sequence add check points sp that sequence can be restartable on failures use that it perform the functionality required by you.