DSXchange

Yes, since the job got aborted, you might need to reset the job before the second run for the new set of parameter to come into act.

You already got the substring... What else you want from the main string.
I guess you are missing out someting.
Is it you want to know the position of where the substring present or to know the presence of the substring in the main string?

Use Sort stage.
Use two key in Sort stage, 1. Some unique field or ID, 2. Timestamp (Descending).
Retain first.

No, dscc is a client utility. Server handles only compiled code.

Make sure that Date field is not Ustring.

How can be a Date be Usting

out_diff_mc.change_code = 2

Are you checking any value or assiginging a value of 2 to out_diff_mc.change_code in the stage variable svFermSpec?

What is the value of e30_dat_fin_mens. Is your output field nullable?

Hi Vinod,
Thats nice to see that you got rid of your issue. Please let me know, what happens when you execute uv from your command prompt.

jasper wrote:A completely other scenario: If the number of inserts/updates is large and it's difficult to find the changed records: Just truncate and reload.
I'm not used to sql server but on an oracle this is the fastest solution once you reach about 10% inserts/updates.

What if you use Change Capture Stage?

If it is locked you should be able to see at cleanup resourse. And you can find the list of items holding the process by selecting the process id and Click on show by process.
If it as any valid job or record holded, you can close the job which holds the record or release it.

Is it Make = AcutalMake And Mode = IncorrectModel?

In addition to that, say if you have 5 columns comming in and you can make one as the key column and which will fall in higher level say 02.
And rest of the columns can be marked to subrecords for the first column. i.e., 05.

Dare to search

Hi Chulett, thanks, and from the days I want to calculate No. of years and No. of months. Ex: D1 is 2006-01-23 and D2 is 2004-10-15 then the result should be 1.3 yrs. How should I proceed for that? Any idea please? ArndW I am not able to read your message fully. How to get the full message? thanks ...

Its better to do it in Database.
You are limiting the nubmer of rows at very first stage.
Since it is a Sever edition, you cannot expect more optimal solution from DS, provided the temporary space allocated in DB is big enough to hold the temporary aggregated groups.

You need to search the forum. This has been discussed many times. Ok, when you use the lookup against Hashed file, the performance will be better. Always prefere lookup when you have a comparatively less number of rows in the reference link. Though its for parallel Benchmark has been provided in a b...

I dont find any group by stage shipped in Server edition.
Is it a plugin