DSXchange

I want to avoid the Warning message. My problem is, Even though I am doing a substring and a trim, I am getting data truncation warning. Why is this happening, am I missing many things here.. Is the string a part of any of ur field and you want to retain the whole string ?? Yes, I would like to reta...

Did you check if the Unique Constraint is having all the 5 keys included on the database side. How is the constraint defined on the table. If it has all the 5 keys then , yes it would be an issue using only 3 keys while loading as it may have duplicates on these 3 keys though not on 5 keys.

There is this help in pdf Windows servers only. You may need to stop or restart the DataStage server engine , for example, when you want to shut down the server. To stop the server engine: Close all DataStage clients. Log on to the DataStage server as a member of the Windows Administrators group. Ch...

Yes Chulet , it can allow only two columns...

How to define columns in outputs for folder stage.[/quote] You will have to specify two columns or may be more based on your req Say two: 1. Filename, Varchar 255 (this column must be defined as the key and receives the name of each file being read from the directory.) 2. Record, LongVarchar 9999999...

Provide FolderPath in Stage Properties and in the Output Properties provide the Filename WildCard as say *.xml depending on your filename extension.

HTH

Hi, When I execute the SQL query in the database its completing in 2min or so. However, for the job to complete the run, it's taking more than 30min. Thanks Hi, Whats the SQL query you are running in the database, is it an Insert SQL or a Select clause. I am trying understand, if its a simple selec...

I would put a Transformer in between Lookup and DataSet and map the necessary columns.

What do you mean by transferring data and not file. You have to mention the destination filename in FTP stage and your source file gets in there.Are you trying to delete your source file once FTP is done?

Can you build a job sequencer for that. If yes,you can can achieve this with a job like JobActivity---Sequencer(ALL Mode) Then Delete the file | sequencer(ANY mode) | Notification Activity | Routine Activity(where you may have call a routine which will abort the job after 1 warning) One way of doing...

Hi , The source rows that are getting dropped have a special character in it.This wont allow me to paste it as it is.Its a square block between the words. Does this help? When I paste it looks like below here —————————&...

Hi Ray,

all the rows are processed but the the target description column is empty.

Yes , This is how my source data looks like. What is the best way to handle this. Does this mean that the NLS map MS1252 is not able to handle the data or is there anything else I need to check here before coming to a conclusion.

Appreciate your comments..

Thanks

Yes DeepakCorning

couple of the source values in 'Description' column that got dropped are

Clothes Issue: 62082-04BOL?edition # 82 of 200 leaking
XL Chassis: fork locks ?falling out",

Thanks

I could find a similar question as mine on the forum, but its not giving an answer though..

http://dsxchange.com/viewtopic.php?t=10 ... 4b0352855d

please let me know if you need more inputs..