DSXchange

Can you parameterize the values to take env. variables?

Whoaa After 9 years same situation with DataStage Pay/Rates.
Whereas Gas prices and comodity price doubled and four-fold expanded...

Again I don't have 8.1,

In 8.5 Connector Stage.

• Select "Generate SQL" to "No"
  Select "Read Select Statement from file" to "Yes"
  click select statement box and "..." browse to your SQL file.

Note doing it in above order worked for me.

That was always attributed as a "must have" feature.
I surely know that its there in DB2 Connector Stage and EE Stage and Plug-in it should be there. I'm unable to check it as Plug-in is out in 8.5

I'm in same situation Message Id:IIS-DSEE-TUXX-00002 Message: TRAN1_1,0: Internal Error: (xfer_->initialFixRunLength_f == initialFixRunLength):./../include/apt_internal/api/transfer_rep.h: 739: Buffer and schema variable padding do not match. Data corruption will occur. Traceback: Could not obtain s...

In Lookup Stage(s), Change Lookup condition from Drop to Continue.
I suspect a lookup failure is causing a drop.

You can enable/use "reject" in Lookup to capture/identify what are failing...

New rows in source are having values that are not there in lookup?

Place a transformer before target XML and generated unique values using @OUTROWNUM derv. to debug grouping issues.

Place a transformer before target XML and generated unique values using @OUTROWNUM derv. to debug grouping issues.

Compare with a simple select Job Vs Aggregator in Job. I assume the throughput from Source stage is a well to note measure in depicting overall performance of your Job. I will also suggest dumping the data into dataset and using that as a source to compare your results and see if there is any improv...

With parallel compatabilities of todays hardware/software the data or a file is allowed to read/write at the same time and this can mislead to a dirty read. To avoid situations, .done files are used. In some platforms a Header, Trailer records are used. In most ER Application, details and header tab...

What is Metdata for this column in source and target as defined in that transformer.
Make sure that the Source metadata is nullable.

Try define Character fields as Unicode and make sure NLS is enabled and supported mapping are defined.

I know that parameters are Serial and cannot be embedded in between. Lets assume that you have parameterA = 'Hello World' ParameterB = 'Big' You can combine them as 'Big Hello World' and 'Hello World Big' but you can never get 'Hello Big World' But you can define ParameterA = 'Hello' ParameterB = 'B...

Satya, Can you check NLS_LANG on Oracle Server and dataStage Server. override NLS_LANG in your job with that of Oracle DB. And if that wont help let us know more details from Director log. Well talking about configuring. If this is your first time defining Oracle EE, sure you have to follow configur...

I got a similar situation and I used to count number of lines in file created to proceed, instead of checking for file presence.