DSXchange

Hi All , I have to do vertical pivot in server , my requirement is i have 2 cols A $ B in source table and i want to get one row in output having same A value and different B values in multiple columns. Can any one please show me how to handle this requirement.

Thanks in Advance

I want to run a quality stage job in the middle of my datastage job process , both are on the same server , going down in the process of daily loads i may have to automate the whole process including quality stage in it . How can i schedule and run the quality stage job from scheduling script. I am ...

Thanks kcbland for your response. My query is just joining 3 tables and as you asked to increase the request time on that query, does it have to do from datastage job or from database side ?

I am running a job which extract data from DB2 stage in which i am joining 3 tables, with a look up using hash file and finally loading into seq file. Table has 7 million records and hash file has 1 million.My job got aborted with this fatal after loading 4 million recs- "src_cog005_ext_TW1tbl_...

Sorting or partitioning are always recomended before you do a join but it all depend upon what type of join and what stage are you using for joining. And posting this topic in parallel forum will get good response.

I am using single row since I need xml header with each record i cant use aggregate all rows. This line feed is coming for some records whose length exceed 4096 character which i noticed now. All the xml records are not same in lenght since it can have repeatative columns.

Hi - I am generating an xml file using a sequential file , in some of my records i am getting new line character like a small square box character, my output file contain one column with lenght 4194304 and as varchar. Basically i am generating xml records in sequential file by dumping all xml the re...

Finally i got it, what i did is i used varchar and and gave delimeter as '000' and quote = '000' then trimmed the column i got all rows in diffetent lines with "<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE TCRMService SYSTEM "myTCRM.dtd">". It also work wit...

I am trying to trim those spaces but i am not able to may be because it is a char , i tried all functions i know like convert , replace ,change etc but still not working . Am i missing something ?

Ernie - I tried the logic its working but since i am giving char to my huge output column its giving all spaces between two records , since i am using fixed width sequential file in output. Other than that i am getting the format what i need.

Ernie - I gave the output link to my xml output stage which goes into transformer and i mapped all the fields into one column with varchar and long lenth (along with / in description) by concatening all the fields , which is running into a sequential file.But my output seq file shows all records app...

I really appreciate your precious time Chulett. We have new ibm product WCC which accepts only XML files in the format i showed in my previous post to populate its tables. Since i am using datastage to generate xml files after all extraction and transformations my goal is to get that format within d...

Chulett , Do you mean that if i want to generate in that format it will result in multiple files ?

I really appreciate your help and time Chulett and WoMaWil ,Chulett as you told that datastage will generate everything in one line i was wondering if its not compatible to generate the format i want. I tried using formatted output but its giving me some other format. The Format i want to generate w...

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE TCRMService SYSTEM "myTCRM.dtd"> The first line will be generated automatically as long as the key column definition is mentioned properly. The second header (DTD definition) should be mentioned using Transformer stage' i...