DSXchange

Is there a way to specify quotedValue in Netezza Enterprise stage. I am writing to a Netezza Enterprise stage and I am able to change the delimitter but cannot create quoted values. I am using the Load Method = nzload and Write Mode = Replace Since I might have the delimitter (which I have changed t...

Looks like the only way I can use the Replace option , have a derivation in my transformer and still keep the order is if I specify a Create statement in the Netezza stage.

Thanks Nirmal for guiding me in the right direction.

Ranjana.

Thanks a lot for the replies

Craig,

Field3 is not marked as a key field.

Nirmal,

Does that mean that whatever order I have in my column specs in the Netezza stage, If I use the Replace option, the column that has a derivation will come on top when creating the table.

Ranjana.[/code]

Hello, I am using the Netezza Enterprise Stage to load data into a Netezza table. I am reading data using an ODBC Enterprise Stage. This is how my design looks like ODBC Enterprise Stage => Transformer => Netezza Enterprise Stage The order of fields in my input data is as follows field1 field2 field...

Parameswar, We got similar message while ODBC configurations. Go to .odbc.ini file and change the path from #Branded_ODBC_DIR# to corresponding ODBC install dir. [ODBC] IANAAppCodePage=4 InstallDir= #Branded_ODBC_DIR# Trace=1 TraceDll= #Branded_ODBC_DIR# /lib/odbctrac.so TraceFile= #Branded_ODBC_DIR...

Folks, I have a project lined up with DS+PeoplesoftEPM. I am very new to this combo. I knew recently about this OEM partnership between Ascential and Peoplesoft. This is what I know about this bundle: The DataStage license bundled with EPM is a limited-use license. It allows the inclusion of any sou...