DSXchange

Did you check your Director log for the job run? It is possible that you can locate them there. Do you have any empty Varchar? Include a copy stage before your sort and write the same into another sequential file. Do the same after aggregator. This will give you an idea of rows passing. Btw, scope o...

I will suggest you try from the given information rather than asking the full solution.

We expect some effort from you also - apart from typing your requirement.

What does 2 year constitue ? What is 2 years from 29/02/2008 ?

365 days per year or 12 months per year or only 2 years increment.

For first, you can do a DaysFromDateSince().

For other 2 options, search for DateToString() and StringToDate().

At initial stages, you will not have all mapping defined. So it will not be possible to hold the columns.

Mapping them to any value may not be valid.

So it will be useful to include a modify stage and keep only the required columns for now. Later extend it.

That definitely cannot be the complete unedited message.

Post in full.

This is an all-volunteer site. So words like "urgent", "asap", "immediate" etc do not have any effect. All threads posted are urgent to the respective individuals. If you want immediate response, you can sign-up for a 24x7 support from your official support provider. Bt...

There are many items you can send as unique for a process.

But what is your intention about it? i.e. how do you plan to use it later?

Sort stage ignores duplicates and does not drop it.

What is the sort in the transformer ?

Without full design, metadata and sample data it is not possible to comment.

Try to locate the missing / dropped records and find the reason.

Search for dsjob

Copy-and-paste the transformer and change the derivations.

Make a copy of the job and set it to 'auto generated'.

You will see either :1, :2 etc or '?' in place of your source keys linking to reference.

Make it then.

Where is your field positions for reference key?

Post the unedited errors.

Also give an idea about your design.

Have you got any user-defined sql?

can you post your sql?