DSXchange

Ok then in input stage of Database select the option

Generate Select statement and enter other clauses.

There just give the join statement

where A.columnname=B.columnname is Null

Thanks ArndW. That was my question. So first I need to FTP to Unix server then use unzip. Rite ?

Use

Cats(A.Col=B.Col ) = sv1
If IsNull(sv1) Then sv1 Else @NULL = sv2


Thanks

Can a file be unzipped in Datastage, installed on Client with OS=Windows? Is is possible without moving it to server, with OS=Unix?

Thanks

Which driver you are using for this ? ODBC or DB2 ?

Hi Ray,

I am using generated SQL and user defined as well the where clause and order by clause to sort data before changing in tx.

Hey Kenn,

yes i found out its Oracle stage causing prob. What shall I do now? could you guide me out.

Hi , I am pulling data from Oracle using transformer to change i/p and load it in to a hash file. Transformer has many IF THEN ELSE condition used. I tried to optimize the job using stage variables and inter process row buffering. But still not satisfied. Plz let me know what else i need to change i...