DSXchange

Yes this is what i was looking for

thanks a ton......

What do you mean?

Can you please Tell me the syntax?

Hi All,

Is there any way to query the dataset to find the duplicates based on the column name?

Will this work on all the flavours of unix?

[1,1] is nothing but substr, there is no function with that name in parallel job, but yes with server jobs we have that function called Substrings()

This should give you expected results.

Upcase(Column_name)[1,1]:DownCase(Column_name)[2,Len(Column_Name)-1]

i had to define a 35 byte dummy field in the begining, i got this from the business.. thanks ray for your suggestions and valuable feedback.
greatly appreciate your suggestions in this forum.

FYI i have already searched in the forum, i found only one post which was not so helpful.

Hi Dsxchangers,

Can anyone please explain me what the below mentioned error means

"Tag value: does not match any tagcase for tagged field"

It mentions about the record types?

Thanks

Problem solved.....

One of the columns size was missing,.....

Thanks for your suggestions...

1. Check whether you have same number of columns in your before and after link. >>> Yes 2. Verify the key column and change columns, and see whether you add any surrogate or generated column in your before and after column list or not. >>> No there are no surrogate key. 3. Check whether you are doin...

i have 100 records in before dataset and 100 records in after dataset and from CDC i am getting 200 records......

Note: both before and after datasets are same.

Properties info..

1. Drop output for copy= True
2. And the rest all are set to FALSE.

Any ideas any suggestions......?

The Data from CDC stage is getting added each and everytime i run the job, Note: I am just comparing the same datasets i.e same data. The Key column i am using for cdc is a varchar column and i have trimmed on both the columns before doing cdc....not sure what else is missing. Yes also i have done H...