DSXchange

thanks all for your replies..I am getting NULLs in database.I was confident enough but the counters were many.Hence I posted but yes it is my fault to post it before testing on my own

Is that true that if we use SetNull() to a nullable decimal field ,it goes as 0.00 in to database???I really felt wierd when most of the people said that.

Hi,
Would someone let me know how does CDC work in case where both before and after links have nulls in change value column for an existing key value?Will it be an update or copy??

Yes Ray.
I am mapping that column to the output link since I have to update the records in the target table with the value coming from after dataset.Only change is not captured based on that value.Is there anyway to eliminate those warning through someoption in CDC stage itself?

yes still the warning were there.

Is that the only way?I couldn't understand the reason behind this warning.

Yes,If no otherway is found.

Hi All, I am getting the warning below and warnings are not allowed in our project.I am using the column mentioned in the warning in both "after" and "before" datasets but excluded that from being a value column and it is present in the output column for the updates on the tables...

I am writing mulitple update statements in oracle enterprise stage(target).But i am getting an error " main_program: (aptoci.C:456). Message: ORA-00911: invalid character" and the job is aborting.The similar query worked to load SQL Server tables but for oracle it is not working.Would some...

Is auto partitioning disabled in your environment? $APT_NO_PART_INSERTION=1 Or, the copy stage was probably optimized out by the engine at submission. In that case, probably no partitioner was inserted in front of the dataset stage when the job ran and therefore the data was not repartitioned. You ...

I have Seq.file as the source then copy stage and a dataset.The partition in both copy and dataset is "Auto",I observed the dataset is created on only 1 node though the job ran on 4 nodes.I assumed that copy stage invokes round robin by default and the records would be distributed among th...

The input record in a seq. file is ABCDEFGH .can we get the output as A B C D E F G H? One of my colleagues asked me this and I replied that we can't.Probably it is one of the interview questions but is it really possible? If the record length is always same then we can pivot(horizontal) ,but the re...

The header gets rejected from the sequential file stage but the job is aborting saying there is import error in the second record which is actually having proper data

Hi ,
We are receiving fixed width binary files from mainframe environment which contains header info in the first line.we have to skip the first row and load the others.Please suggest a way to do it.
I tried by sending the first record to reject but the job is aborting

I changed the File block size to 1 and attained the desired output.
Thank You All