DSXchange

Also i suggest to use sql loader insted of upsert , because upsert method are heavey to database tahn sql loader , it searches all the records by the specified key to update them , if it fouund them , it updates them , then generate insert statment with the reset records to be inserted ,,,, and from...

You can use CurrentDate() function. To add n days to current date, use CurrentDate() + n To subtract n days from current date, use CurrentDate() - n This fuction is even listed in Functions> Date & Time in derivation field in Transformer. i try to use the above method , but it gives compile err...

How many records are read ? try to take sample od the file about 10 records , save them in a new file and then run your job on the sample data to check that the problem is not in number of records

Does the table contains any previous data ? or it is empty ?

ray.wurlod wrote:There is more in .uvconfig than in uvconfig. Since you don't have premium membership, you will just have to take my word for it. ...

Your word is enough for me sir

Simply the table is set table , not multi set , so it can't contain duplicates , and the 20 rows received must be 1 row duplicated 20 times , check this and feed us back

M.Gendy

Good advice but wrong technique. The .uvconfig file will never be the same as uvconfig - for one thing it doesn't contain all the comments and, for another, it contains additional information, for ex ... hi ray, I couldn't read the reset of the your reply because it is a premium content, and tell n...

Check the NLSMODE setting in the uvconfig file. If NLSMODE is 0 then NLS is not available. ... here is the trick , if you've done all the abobve , and check uvconfig and found that NLS is set to 1 , but still the NLS button in Administrator is disabled , then check the file .uvconfig , it is a bina...

babuselvan wrote:Can we have that surrogate key genertor function in server job mode?

no , you can't use this stage in server jobs

You Can Use Surrogate Key Generator , either in sequential mode , or in parallel mode using round robin partitioning method

Why hash file is used as the intermediate file? Thanks for the advice, it's not an interview question. i want to know that why hash file is prefered for intermediate file rather than sequential file Who said that hash file is preferred to use as intermediate file rather than sequntial file in Serve...

femil wrote:

ray.wurlod wrote:To which "backup file" do you refer? ...

sequentional file stored in server

what do you mean with your questuion ?

you could acheive right outer join by setting lookup failure to continue , and swap refrence link and stream link to obtain the correct side 'left or right ' , but i think you couldn't implement full outer join using one lookup , why didn't you use join stage instead ?

chulett wrote:The only way it might work is if you add the 'Preserve Type' option and it seems that wasn't added until the 7.5.2 release. Let us know. ...

yes yes yes , it is working now , many thanks chulett for your help

Hi All, i just have a little question , does Aggregator Stage min and max functions support time stamps , i tried to use it but it gives an error saying that couldn't convert from timestamp to dfloat , but i beleive that it worked with me before but in another envirnoment , i just ask to know the ab...