DSXchange

The source file is a simple text file with one column

COLUMN1

Test1
Test2
Test3


Arvind

Hi All I am using the 8.0 version and have the following logic in the transformer to get the previous row value checked to raise unique sequence numbers Mapping as viewed in transformer <B>Derivation -------------------------> stage variable</B> SOURCE COLUMN ------------------------------ > current...

We have defined a simple job that is using the IDOC Extract stage to extract IDOC from SAP. We have followed the documentation to define the listerner on the server and the rfc port on the SAP side and can view the IDOC getting received by datastage as per the IDOC log in the DataStage Administrator...

Hi Thanks for your responses Actually in our situation since we have | as a delimiter and the fact that we can get pipe's in our data means, I cannot set the quotes to none The quotes attribute set to double allows us to have pipes in the data But it looks like i have to do some transformation of th...

Hi All My sample file qtest.csv in unix has two lines ( though it is CSV it really is delimited by a |) "arvind"|"tes"ting" "newtest"|"testing" I am trying to read it via a sequential file stage in a PX job The record delimiter is set to be a Unix new lin...

Actually it is a bit of both the compilation hangs in my opinion in that it runs for foreever Due to concurrent licensing issues we have a process that goes and kills sessions that are not active for over 2 hours So while i work i am looking at it on my other screen still saying it is compiling plea...

Hi I have simple job which does the following 1) reads from the dataset 2) does remove duplicates to retain unique headers 3) does a lookup to pull in all the details for the headers 4) transforms each looked up column with if IsNull(Link.Col) then '' else Link.Col 5) Writes to an ouptut dataset WE ...

Thanks for all your responses

I will try out these suggestions and report back on how it went

Ray.. currently our scheduling tool is ActiveBatch but there is an effort to find a another scheduling tool.

Will report back in the morning


thanks
arvind

Dear all +++++++++++++++++++++++++++ Main objective : To capture metrices or stats for all the jobs running on production and or test. +++++++++++++++++++++++++++ The last two weeks or so i have been working the Kim's ETLSTATS program. Kim has been very kind with his time in responding to my emails ...

Hi According to the orachestrate manual "By default the oraread operator runs sequentially. However, you can direct it to read from multiple partitions and run on all processing nodes in the default node" Typically most reads from oracle are sequential. I tested out a simple job which take...

Just another debugging tip, try hanging a reject link off your oracle enterprice stage and set the reject flag to true inthe stage. This captures any rows that were rejected by the database for some reason. The best way is to see truely what your source query returns, ensure there are no constraints...

I was going to say the same as the previous poster..

It looks like you might want to review your metadata to ensure there is not mismatch there...

I have not seen this in the surrogate key generator error..

arvind

Surrogate key generator is not persistant in px jobs. It expects you to remember your last generated number. YOu could write last sequence into a seqencial file , so in your case you will write 70 to a sequential file. On the next run you will read it from the sequential file and pass it as a pareme...

Have you tried to handle the null value by setting the null field value with empty quotes in the extended properties of the column where you have null in the source files.

arvind

I would think, that
With your nullable=yes for one and nullable=no for the other, if the column names are same going through funnel stage you would still get an error at run time if the compile goes through.

Arvind