DSXchange

Hi Munish,

Well, I am confused now

Is your reject link writing to a sequential file or an Oracle table?

Hi NaveenD,

To implement the logic, that I suggested, you would require 2 transformers. If you want to implement the first part of the logic in the transformer that you already have in your job, then you would require only 2 transformers total, if not 3.

Hi Titto,

This topic seems to be a duplicate of the one you posted in the Server section. Please dont post in the wrong section. Please delete this thread.

Hi NaveenD,

Yes the job would have to use two additional transformers.

Hi Munish,

The same topic has been covered in great details earlier. Here is the link for it

viewtopic.php?t=94042

Hi Shivan, Well thats a different error. It would be nice if you start a new thread, as it is a different error and seems like your initial problem is solved. Anyway, it seems like your error is in the aggregator stage. Make sure that 1) You are sending the sorted data to the aggregator 2) You are u...

Hi NaveenD, I would do it in two steps 1) You can use stage variables in the transformer and keep concatenating the RC column into another dummy column. 2) In the next transformer you can take the value in the last row of the dummy column which will contain the concatenated RC value of all the 7 row...

Hi Shivan, You need to use the reject file functionality of the transformer. Use another file to store the rejects and make sure you check the reject row check box in the transformer constraint. Then you will get a warning in the job, saying that there were so many records rejected. In fact, it is a...

Hi Shivan,

Do you have any constraints in your transformer stage. Also, see the rowcount on the input,output to each stage and see in which stage you are loosing your rows. My suspect would be that you are having some constraint in the transformer stage, which is rejecting some rows.

Hi,

You can achieve this using the appropriate stage (ODBC,ORACLE etc) depending upon on the database on which your tables reside. In these stages, you have a place where you can put in your User Defined SQL.

Hi,

As far as I know, You can't use one Environment Variable ($PROJDEF) as the value to another Environment Variable (SRC_DIR).

Guys,
Please correct me, If I am wrong.

Hi,

I am confused, about what the actual problem is as you are speaking of both about SRC_DIR and $PROJDEF

Are you trying to use $PROJDEF as the value for the parameter SRC_DIR ?. Please clarify.

Hi,

It's not running sucessfully.

What's the exact error you are getting?. You need to provide more information, so that we can help you.

Hi,

I know we can do it with hashed file bu i'm developping on parallel job.

Why don't you try to use Lookup,Join or Merge stage to achieve this, as these are all parallel job stages, equivalent to a hashed file?

Hi NaveenD, 1. How do I generate the reject report? I really didnt understand what you meant by this, but this is what I do. I usually send the records that don't meet my criteria to a reject file ( sequential file with .csv extension and make sure you check the box that says, first line is column n...