DSXchange

Thanks Chulett.

Is there any alternate way for this scenario?

Thanks,
srini

Hi,

additional information.
Reject error code:0
Reject error text :row not updated - update mode

Thanks,
Srini

Hi, I have 6 columns in Table.No primary keys. But unique index is created on first 5 columns. I tried to update the table by taking these 5 index columns as key columns. 2 index columns have null values. I have taken Oracle connector for Update. Job went fine with no warnings.But record is not upda...

Hi,
Pivot on Table B and Join.

I think this will work.

--------------
Sreeni

How many OutPuts?
One or many?

-----------------------
Thanks,
Ssreeni3

Try this:
Please ensure In Sql query:
Between Minimum_Value AND Maximum_Value

Then It works properly.
---------------------------------------------------------------
Sreeni3

Hi PPP,
Please specify the records of input,output and rejects for better understanding.
--------------------------------
Srini

Hi Sachin,

For column data:Transformer convert function
For entire file :unix sed command

--------------
Sreeni

Hi jerome_rajan, My opinion is: 1)Oracle DISTINCT keyword treats first record in the group as a unique record and the remaing records in that goup are duplicate records of the first record based on the value/values of key/keys used in the DISTINCT. 2)RemoveDuplicate Stage has an options Retain First...

Hi deeplind,

That function is available in BasicTransformer stage.

---------------------------------------------------------------------------------
Sreeni

Hi Experts,

Thanks for your inputs and valuble suggestions and openions.


Thnaks,
Sreeni

Thanks Ray for your reply.

My doubt is:
Which scenarios,we may give the same Select statement to the Update query also.

We are using Change Capture Stage in the Job.

Thanks,
Sreeni

Correction to my post:
Already a select statement is there for Insert Query of Target Oracle stage whose mode is UPSERT.What happens if we write the same query for Update?

I observed this in one of my existed jobs.Is there any specific meaning for it?

Thanks in Advance,
Srini

Hi Experts,
Already a select statement is there for Insert Query of Target Oracle stage whose mode is UPSERT.What happens if we write the same query with select statement for Update Query?

I observed this in one of my existed jobs.Is there any specific meaning for it?

Thanks in Advance,
Srini

Hi,

Oracle target stage has an option to capture the Oracle_Rejected data.

---------------
Sreeni