DSXchange

Surely the Change Capture stage requires identical key partitioning (so that valid matches can be made) AND identical sorting (so that memory can be efficiently used). Try adding sorting on both input links, using the key column(s) as the one(s) to be sorted. That way, out of order rows will not be...

kris007 wrote:

deployDS wrote:

kris007 wrote:I am doing Hash partitioning by the same key field in both inputs and also performing hash partitioning again in the CDC stage..

I didn't understand this part. What do you mean by partitioning again in CDC stage?

Yes. Just in case..

did this got resolved

thanks
arif

Hi 1.When we are writing the per-record code in logic tab of buildops(built type) what language syntax does it accepts .Is it basic or C syntax. 2.What is the significance of properties tab while creating buildops or what is it used for. 3.I was only able to use buildops when I specify the table nam...

Got it ,We need to use the following command format to generate object file APT_LINKER APT_COMPILEOPT <<programme name>> -o objectfilename.o APT_LINKER,APT_COMPILEOPT are the environment variables whose values can be obtained from administrator. Thank you all who helped me solve this and ofcourse al...

Try the .o library instead and define that in DataStage as an object. Let me know if this works for you. I could not get a .so to work on Linux but the .o does! Sean when I used the command g++ -O -fPIC mutiplyrtn.c -c -o mutiplyrtn.o only a .o file is created,and in datastage manger object type I ...

Hi I am trying to compile a C++ routine on solaris ,I used the command g++ -O -fPIC mutiplyrtn.c -c -o mutiplyrtn.o , the object file is created ,after creating the routine through manger ,when used in transformer ,the job gets compiled but it fails at run time with error . Transformer_3: Failed to ...

You will find In Field Defaults: Defines default properties for columns written to the file or files. These are applied to all columns written, but can be overridden for individual columns from the Columns tab using the Edit Column Metadata dialog box. Null field value . Specifies the value written...

Null Field Length property is for use with variable-length strings. You do not have any of these in a fixed-width file. Use Null Field Value property instead (they are mutually exclusive), and make sure that the value is of the correct length. How do you chage to Null Feild Value property I dont ha...

Typically this happens to us when there is mismatch in the datatype , specially Fixed width fields carrying Null Values. You can also check the below link http://www.dsxchange.com/viewtopic.php?t=97873&highlight=When+validating+export+schema I know DSXchange team is working on this :wink: Is th...

thumsup9 wrote:I think I am not clear here, Whats the Source Field and target field datatype and lengths

Both in source and target the feild type is float (22) but when import the meta data it comes as double

Hi While loading the data in oracle using orale load option I got the following warning Ora_qty: When checking operator: When validating export schema: At field "M_QTY": "null_field" length (16) must match field's fixed width 8 The feild M_QTY in target is of type float(22) and n...

Ultramundane wrote:Hmm. I get the same error message when using the timestamp datatype with nanoseconds on Oracle 10g. I have to convert the columns using TO_CHAR.

I just have microseconds

Ultramundane wrote:What version of Oracle and what datatypes? Do you have any timestamps?

Its Oracle 9i ,it does have 3 timestamp feilds,varchars and decimals,I dont have this problem when I access data from other servers but only this particaular server throws errors
Thanks
ARif

Hi I am trying to load the table definations through Import Orchestrate schema,and I am getting the following error F TUXX 000002 11:45:12(000) <main_program> Internal Error: (colDesc):orautils.C: 1714: getColDesc failed. Traceback: [6] APT_FatalPath::msgAssertion(0xfcfbacff, 0xffbf6410, 0xfcfbad07,...

No kind of job can reset itself. It must be reset from a higher level. Perhaps you need to build a master job sequence. What if the master sequence aborts or stops(if stopped manually).One more issue I am having is crontab fires the sequence every hour ,and sometimes the sequence takes more than on...