DSXchange

Oracle Database .

Craig ,

Thanks for the response . i will try that option but I dont have indexes on that table in staging though i have in Warehouse table . Will it not impact performance ?

Thanks
Nag

i think you can use orchadmin also to view a particular partition

Hi Everyone , I have an issue with loading of one of the table . Here are the details a) Incoming file needs to be loaded into staging b) From staging into Warehouse c) Daily load : 20 million records ( delta ) d) Needs to do type1 updates . c)Unloading the data from warehouse based on the records p...

Cannot create means what ? Are you geting any error message ? Is it giving problem during compilation ?

you need to perform nul lhandling .This is very common warning message .

Nullability is getting changed in the lookup .

I think something is wrong in null handling of timestamp fields .Give the null field value . Is there any reason why you are reading with correct datatype in seq file .It will automatically reject invalid data .

Define those parameters in parameterset and use different value files for diff environments

Hi Ray ,

Let us suppose that i have not set the PWD correctly . Why the job is getting completed successful in the 3rd or 4th attempt sometimes ?

Anyways I checked that the path is correctly set .

Thanks

If its a mainframe file , ask for COBOL definition and import the same .

Do you mean to say that the parameter sets that you are passing are different ? Then its possible .You can pass as many parameter sets as you can .But you should not have the common parameter between these parameter sets . The value files are nothing but instances of these parameter sets .

I have not tried but conceptually you cannot do that .Its as good as passing each parameter twice .

Hello Everyone , I am facing a sporadic issue in datastage . Some of our jobs are getting aborted with the below error message : Internal Error: (0):util/pathutils.C: 373: Unable to determine current working directory! This very likely due to a problem with file permissions on the directory or direc...

you can also do it in unix using dsjob command and passing the parameter .

for i in ` cat parameter`
do
dsjob -run -param $i ......
done

what do you mean by 10 resource and 3 applications ? what exact information you are looking ? Give more details .