DSXchange

Hi All,

I am trying to use an XML input stage. As I add it to the Designer canvas I see the icon as that of a builop stage. Is it installed ? Whats happening? It does not look like a normal XML input stage.

Any help.

Thanks

Please use a more meaningful subject line for your queries.
Search the forum for 'Pivot'. There are many posts matching your requirement.

hamzaqk wrote:i would take your source is oracle ?

Well, its a flat file being sourced from Mainframe DB2.

-thnx

Hi, I'm trying to load a teradata table using Enterprise stage.Source is a dataset. Mode Write Truncate. While loading, the job aborts due to Datatype mismatch for column A, where col A is Decimal[20,0] both in source dataset as well as in Teradata target table. I read around some forums that Terada...

hi all,

A very basic query:
Do these versions provide backward compatibility i.e. a job built in 7.5.0 be available for editing and execution in 7.5.1 and vice-versa:

And could anyone tell what's the difference between these releases.

TIA

Hi all,

We have a requirement to generate the output file layout/schema in the form of a sequential file along with the data file.

Can someone suggest the ways to do it without any manual steps (eg. copy-pasting schema from column definition etc).

Thanks in advance.

Thanks Kumar for replying.
What i understand from your reply is, in the above scenario i should go for Transformer?

Hi Kumar, one related query here. While using the schema file we dont get to see the column definitions in any of the stages(since we dont load it explicitly for obvious reasons). So lets say, if i want to use Hash partitoning for a join stage in the job which uses schema files and rcp, how do i do ...

Hi all, I have this generic query related to design approach. How do I make a call for using either a Buildop or a parallel Transformer for simple transformations? For eg, lets say if I want to simply trim the join keys, some data types conversions and rename them before performing a join, should I ...