DSXchange

kunal, thanks for your reply.

Chulett, all are processed to keep history information and displayed the same using web interfaces.

Hi HKonishi, Have you tried datastage NLS settings? Is you local in Oracle 9i & 11g is in Japanese and if you are datastage NLS setting local is in English?

Quick fix to the spacing issue in Char datatype would be using datastage Trim() function.

experts, This thread is a continual discussion on earlier thread. Please refer to the following topic... http://www.dsxchange.com/viewtopic.php?p=334305#334305 Can you please address the problem that Parag has mentioned in his reply which is as follows.... But there is a problem with both these stag...

Fair enough, Chulett :D As you pointed out I am going to chime on 'the same problem' in new thread. See you there. Peace!

To Kunal, since it's a related discussion, I would opt for posting my queries in this thread itself rather than creating lots of threads under same topic. What do you say? :D :D :D Also, you have not address the problem that Parag has mentioned in his reply which is as follows.... <B>But there is a ...

ramku, horizontal pivot is only possible and not the vertical. You have to apply some other logic but cannot use pivot stage for your purpose.

There are two options for processing Delta Data. These are CDC (Change Data Capture) and SCD (Slowly Changing Dimension). Both are almost same as per functionality but SCD is faster as far as processing speed is concerned. But there is a problem with both these stages. The input records must not ha...

As mentioned chulett & ArndW...
Can you check if the job1 has produced the desired Dataset at the location "home/dsadm/Ascential/DataStage/DataSets/eng/Ord" prompted by error?

Investigate why job1 could not create Dataset resulting sequencer & job2 failure...