DSXchange

1. Use row Number Option in Sequential Stage.
2. Define a lookup to Oracle with SELECT 10 As rowNumber from Dual as User Defined SQL.
3. Join to Row Number from Sequential Stage. Condition Not Met - Drop
4. Update your resume.

Use the filter property in the Sequential Stage
awk 'NR == 10'

although I like the @INROWNUM better.

Hey, this is fun. I'll bet there aren't more then 10 more different ways to do it.

Try it locally first to get comfortable with schema validations and Datastage and then branch out to using a URL. 1. I would copy http://xmlns.oracle.com/streams/schemas/lcr/streamslcr.xsd"> to your local DS Server machine and to your client. 2. Import the xsd via the Import tool to make sure t...

What is the source stage of the look-up? Dataset, fileset, Flat File, etc.? You appear to be saying that the source of the lookup is static, therefore it isn't a DBMS stage of some kind. What it is?

The multi-load stage needs column names in order to build the script. You'll notice that your script SQL statement has none; 0010 insert TEST.Testtable () values (); No can do-ski with RCP. I would hazard a guess that ONLY the Enterprise Stage can be used with RCP and Teradata because I have the ver...

This is a comment and is not related to your problem but if all of this is invoked with a Sequence then you've hit the Trifecta! A job being run by a routine inside a transformer inside a job inside a Sequence. I like the added complexity of running that job from the routine when that job resides in...

The name of it is Asset Interchange. It is promised Q3 of 2008 in release 8.1. I hear it will not be integrated with Clear Case at that time but that is the goal.

My RCP enabled job works fine with the Teradata Enterprise Stage. This indicates that my problem is NOT RCP per se. I need to do Upserts on very low volume and so have switched to the Teradata API stage. The job fails because no columns have been defined to it. I don't believe RCP is supported for t...

I must be missing something crucial to this discussion since it appears intuitively obvious. The parameter values are available at runtime. Simply reference them in the job and write them out to wherever you want. There is no no need to go back to the logs after the job has run.

ArndW - Actually Mr. Duke said he didn't think it was not used.

I don't think RT_BP is not used on PX jobs.

Is this really a Server job? Does the reference or stream links contain extremely wide rows? Do you have inter-row buffering turned on? Could certain rows be larger then the buffer size of the Transformer stage?

An audience?

They were either pulling your leg or looking for you to think out of the box. It could be argued that the Copy Stage is a "scratch" stage from a Palette point of view although it is kind of a stretch. The Copy stage can sit in as a "placeholder" or "scratch" stage when ...

It is the complement to the "itch" stage.

Why not? You do.