DSXchange

I can't see any checkbox

How can I turn off the column propagation for the reject link?

Yes, "sqlcode" there is in the column definitions of the sequential reject file

Could you tell me which stage is more efficient:
Lookup, Join or Marge?

We're going process large voulmes of data.

The "sqlcode" coulmn appears in the output link when I check rejected=TRUE (databse stage). This columns appears automaticlaly.

Let me explain. My job reads data from flat file and writes them to database table for example MS SQL Server. In the Propertise tab (ODBC) I set "Write mode = Upsert" to reject rows to flat file (Sequential_File_10). For every destination table I have the same error: "Could not find i...

One more question,
Why it doesn't fit to PX?
I've read that it works for SMP system.

Ok,
I am blind.
I'm ashamed.

I 've found
Thanks.

What am I doing wrong that the following error appears :
"
Sequential_File_10: Error when checking operator: Could not find input field "sqlcode"
"

I use write mode=Upsert and reject=TRUE.

On Solaris system there isn't too.
How can you explain that?

In documentation I've read that there is BASIC Tr stage in DS PX.

But... I can't see it in DS Designer.

Platform - Windows XP.

Help.

Anka

I don't need retrive the first rows.

I just want to limit the source rows.

But there aren't hashed files in DS PX.

Hi,

It's me again

I know that I can capture rejecting rows from every Trnasformer separately.

But I'd like to collect all rejecting rows into one files indepednently.

Do you know any Macro or function to do that?

Thanks,
Anka

Thank a lot for your promts.
If you have any other idea please tell me

Regards,
Anka