DSXchange

Hi,

I need to read bunch of xml files with same structure . In server jobs we have folder stage but in parllel jobs folder stage not avilable.How we will read the xml files in parllel jobs.

Any ideas.

Regards,
Pravin.

It is not possible using the GUI. All you can do is to create the new category, move all items from the old category to the new category (you can use drag-and-drop), then delete the old category. ... yes i know that way but i have so many number of inner categories. can we do in unix ? and one more...

Hi,

Can any one tell me how to rename the Category?

Thanksinadvance
Pravin.

Hi, In one of my job i am trying to open the join stage -mapping page only but it is showing white window and I am trying to compile my job,that is giving the following error, prepare compile,457:This key is already associated with an element of this collection -(next link name Ex:-DSLink19), I chec...

I don't like this method for large volumes, it is far more efficient if you can separate your inserts and updates into different streams. If you do need to do it, and it's a simple design for smaller volumes, make sure you have a reject link. You will probably find your inserts are being rejected. ...

Hi all, I am using the db2 enterprise stage in my job for both insert and update operations with write method is upsert mode and sql is autogenerated update and insert. But here every time in my job inserting the records only not updating the existing records,may i know what operation carry first in...

It is not possible, it seems, to create a Data Set with zero records. Add a dummy row to each, and ignore it when processing. Submit an enhancement request to IBM, through here or through your suppo ... If i create the dummy record for each dataset every time it will append in the target database.T...

Hi, I am using in my job 4 datasets and funneling the 4 datasets and loading into database.Here the problem is if any of the dataset is not present the job is getting aboted... Above 4 datasets were created by 4 different jobs.The problem is some of the jobs processing zero records. If any of the ab...

Hi everybody, i got following error when i ran my job Error occurred in call to ORPHCallActivePluginInitialize(). i dont know exactly what is the aboe function,where it is needed, this is showing in my quality stage jobs,i am using two quality stages in my datastage jobs,in both stages i got same er...

BalageBaju wrote:Hi,

First Trim that field and then apply 'StringToDate' function.
Hope this will help you...

I used TrimLeadingandTrilig funcion,but warning is still comining

hi all,

when i am trying to validate the input field type is char and convert to date,it is generating the warnings like...

xfmIIPNT0: Conversion error calling conversion routine date_from_string data may have been lost

can u provide the best input for this warnings.

thanks inadvance
praveen

sud wrote:Please switch off RCP only in the input stages to the join, keep RCP on in the joiner output.

Hi,

i did what u said, but their is no change in my target dataset the data is not come.

What is your Target ? Is it a Dataset or Database ? Dataset Data is not visible means, is it showing dataset is not created in the mentioned path or it is simply showing dataser created but no data. that means empty dataset. are you able to view the data without these two options ? The path your pa...

Nageshsunkoji wrote:What is your Target ?

Is it a Dataset or Database ?

Dataset

Hi, Warning Messages- We have to analyse those warnings properly and by max, we have to find the cause and solution for the same. Message Handlers are helpful, whenever your warning is not harming your job and if your unable to find a solution for your warning. Warning like Prior Component with sam...