DSXchange

You need to get and understand the copybook layout first as suggested above.

Thanks Ray & Craig !! So, in this case, if the source cannot provide me the clean data for this column, do I have to code like below in the transformer? IF DKI_AMT = 4040404.04 THEN @NULL Else .... I am asking this because, I have already coded this way and resolved the problem, but not really c...

I have a packed decimal column in the source whose COBOL copybook definition is like 15 DKI-AMT S9(7)V99 There are some spaces coming for some of the records for this column. But my DataStage job which is reading this field as DECIMAL comp-3 is treating those spaces as 4040404040 and loading into th...

What should happen if you have more than 4 same key values (as per your example)?

Run your SQL query directly in the database environment first. It will tell you if there is an error in your query.

Some people are slowly changing the DSXchange to a "knowledge(?) expo" from a "knowledge base" with their over-excitement. In a recent post, I asked a very simple question and got only 2 solutions and around 10 other useless comments. Please think neotically before throwing some ...

It would be great if you can give more details about. what are you going to do with duplicate rcords, are you going to delete or. you might be doing some thing right. and what else doing at same time, are you just try to findout only duplicates with that data, else are you some other process. If yo...

[quote="Sainath.Srinivasan You have not mentioned anything about your hardware configuration. If you are one who has huge memory plus more than 100 TB disk for each node and running in 32 node config, you can easily fit them. On the other hand, if you have 2Mb RAM and 4Mb disk space, you will h...

Forget it. I wouldn't have come to DSXchange if it was possible.

But performance is my concern. Will the performance be ok on 60 column input data of around 10m records?
Any better solutions ?

I know that this question has been asked many times before. But I think my requirement is slightly different.
I have to capture only the FULL duplicates (only when data in ALL the columns is identical).
I need an optimal solution as this job should handle more than 10m records.

Any suggestions??

How can you download from email quickly if you cannot do it directly?

Can you send me if you have any latest networking guides ?

I have a function or I will write one and give you. But before that tell me how do you want to achieve your objective if I give you that function. ------------------------------------------ If I don't know how to ask a question, then you cannot find anything useful in the thread except "Rolling...

Hi , I have a job which has three stages.. The second stage is not a trasformer stage...all i want to achieve is 3rd stage should be triggered only and only when there is one row coming out of second stage.... is there any function to achieve this? (I am not using any job control or sequencer...) T...

Mr.GSSr i thnk u didn't get the question i want even records in one file and odd records in one file?is it possible to do it by filter or not if yes then how?? Then why did you ask about Filter Stage? Why don't you refer the documentation if you want use filter stage so desparately and if you think...