DSXchange

I have different columns that i need to transform in my project. For example i have SSN in around 20 tables that i need to transform to a different value. Is it possible to transform the SSN column in all these 20 tables in a single job? Currently i am coding one job per each table. Thanks in advan...

one of my job, sometimes run very slowly and some times as expected fast. it reads a sequential file, remove the duplicate records and insert into oracle target table, using upsert. will oracle upsert with duplicate source data( if i remove the remove duplicate stage) be faster then my current appr...

Hi Gurus, I'm in middle of designing the process and confused which stage to use i.e. Join vs Merge , i can achieve the result from both the stages but we will be processing loads of data and trying to join/ merge 7-8 links with same key value. I wanted to know which of the stage will use less memo...

Thanks for your help guys. The client decided to import the files in CSV format. We'll explore (properly formatted) XML with another project.

Thanks Ernie. I've done what you described, but the issue is that each of the FormattedValue object is a column in a record, but is output as a separate row. Each record begins with - <FormattedAreaPair Level="1" Type="Group"> *****columns here (FormattedValues) </FormattedAreaPa...

Hello, I'm having an issue with XML Input. I've read the XML Pack documents but an not an expert at XML files. My question is with the repetition key. I used XML importer to define the data file. The XML file I'm reading looks like this (I've cut out the first record, but there are 12 records per XM...