DSXchange

Hi.. First time I am posting in this forum. Actually I got struck up in one of my job in which I am using Oracle stage. I am putting data into oracle database through oracle stage after processing it.It's a direct load into table through oracle stage. Job is populating the table,but due to some dat...

Hi, The Format for both the files is not same. one is a reject link file from a sequential file and the second is from transformer n the third is the rejected reccords from table. But I have a doubt here. The structure(metadata) would be the same for all the files right? Because one is a reject fro...

friends, i am using oracle stage to load the records into oracle Db .while loading, few records got rejected due to some reason.currently we are getting sql error code from the reject link,but i need to collect the message(reason for rejection) in a file. please advice in the target table set "...

Hi, I have a source file which reads a csv file followed by a transformer and then oracle_enterprise table. I have put up a reject file from both source and from transformer; At source i have kept a reject link(this file collect the records which are short of commas) , and at transformer the record...

Try this in the sequence: 1.In the user variable activity you must have given the job parameters definitions right? add one more varialbe such as inftctgtfiledate(interface target file date) and the give the value as "DSJobStartDate[1,4] : DSJobStartDate[6,2] : DSJobStartDate[9,2]" eg:if y...

hi, have you checked with the condition that if the look up fails, is the error file getting created in the path that you have specified? if the error file gets created then only your routine says the memory size>0. if there is no error file and look is working fine, then the obviously the error fil...

hi,
are you getting likethis in the body of the mail:
"WARNING - MISSING ATTACHMENT" and the body that you have given.
and also do you have an attachement but the attached file is empty??

yes, you can check it out in your bulk folder of hotmail !!!keep refreshing the page and as maveric said there could be a time lag!

since the corporate offices use microsoft outlook, the chance of mails reaching the inbox is very high even though if there is any junk(until your company has any restrictions)!
Hotmail,gmail,yahoo has a bulk folder, so most of the mails will be directed to the bulk folder !!!

Thanks Maveric i will give it sometime to see what happen. I just want to add few more for this. Firstly, there would be time lag. Also sometimes the unwanted emails may reach junk folder or bulk folder and sometimes it wont reach. Try this out using your Official ID. Generally it works out fine fo...

I just want to add few more for this. Firstly, there would be time lag. Also sometimes the unwanted emails may reach junk folder or bulk folder and sometimes it wont reach. Try this out using your Official ID. Generally it works out fine for the official IDs. I have tried this(official ID). It works...

As Ray said, an email can be redirected to a mobile as an sms. However not in all service providers we have this option. Here in India even though there is this option of sending an email to a mobile as an sms, most of the time it doesn't work. But I am not sure whether this is applicable to CDMA mo...

again the look up wont happen because data is not matching for the key "state". However if u remove the constraint look up failure the job wont abort !

XML input stage would be a better option !

to remove that warning, jus try this one.
In the stage prior to the external sort stage clear the partition. Probably the you would have given as default. Since the data is again repartioned you have to clear the partition.
I think this would remove the warning which you are getting !

Prasad