DSXchange

Or If you don't have any such column and consider all rows in the table as active employees then you can just create one more temp column with any default value and the you can use it as your grouping column.

You must be having some column to filter out "active employees"
You can use the same column as your key in aggregator.
For Example: Status_Flag = 'Y'

Try This:
StringToDate(LkInto_TRNS_SeqGen.Date,"%mm/%dd/%yyyy")

Use the function: StringToDate(INPUTCOLUMN,"%mm/%dd/%yyyy")

My point is that many of them (such as my east Asian customers) can not easily understand these forms. ... Hi Ray / Jwiles I got your point and your concern for others is appreciable :) And for the issue- I have created a new job( which was the last option I have ) for loading the duplicates using ...

Hi mansoor--Thanks for all ur valuable inputs

and Ray we are discussing a technical topic over here(not English Literature) and as far as others are able to understand what am saying I believe its fine

Bro search dsxchange....this ques has been answered atleast 10 times

Thanks

R using the same dataset created in your Test Environment??

As per my knowledge
A node can have one or more CPUs but a CPU can have only one node....
Experts please comment

Hi mansoor

The first option creates deadlock and I couldnt find a way out....thats y i posted this

Can u please explain a little abt the second option...Thanks in advance

for 1st--
StageVar1 = (If DSLink2.Col1 = StageVar Then StageVar1 +1 Else 1)
StageVar = (DSLink2.Col1 )

Output
DSLink2.Col1:StageVar1

for 2nd: vishal_rastogi has already answered

Ok jwiles... thanks all for ur inputs.... still trying to figure out a way Cwong: We can insert using Mload but in my case the performance is a very big factor.....So what I am wondering if it is possible to load a same table 2 times in a single job using two different stages....Thanks If any one ha...

Nopes...no key defined

Thanks for the replies :) I have millions of records and in which thr r some duplicates(few hundred)(complete duplicates i.e, all columns r same) 1) Issue with TD Enterprise Stage is it silently drops the duplicates 2) If i use TD Mload the performance is a big issue for me 3) If I use TD connector ...

One more issue I forgot to mention is that I want to avoid to create one different job for loading the duplicates bcoz I have hundreds of jobs & sequencers already designed having the same issue, so adding a new job is the last option..

Thanks