DSXchange

Set $APT_DISABLE_COMBINATION to 'True'and try to run the job.

Use StringToDecimal Function with taregt column length of 9.
If you need the Target datatype to be Char, you can change it back

Problem Solved : Connection Issues

My Job type is : ORACLE --> Transformer --> Netteza I am just dumping the data from one table to another In Source Oracle , i have read method as TABLE In Target netezza, i have write mode as Truncate, While running the job , it throughs more error saying, Error when checking operator: When binding ...

Hi In my job I am extracting data from oracle tables and inserting it into sql server tables. I am getting following warning messages .. any idea how to resolved it ? Oracle_Enterprise_5,0: Column POUNDS floating point decimal is not fully supported; adjusting the scale. [orautils.C:2383] Thanx in ...

What is your Job Flow?
Is your source file is any database or sequential file?
What datatype you are going to load that column (Decimal or String)?

Hi, My job uses query in a parameter. Eg: select * from personnel is #query# Now I want to put a condition. select * from personnel where id in ('1','2') I want to put ('1','2') in a parameter #condition# so I want select * from personnel where id in #condition# to be in #query#. But when I put a p...

I am using an aggregate stage and am using the count no of rows to calculate the no of rows by grouping on all the 4 input columns. Is this the right way to do? As you are using all the four columns, you can get the output count of the Whole DUPLICATE ROWS, If you want the count of duplicate value ...

i am using folder stage to read files from load directory . My files are fixed width length file .I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) . but in my job its taking only first rows of file.Please help me what i need to define so that it ...

I have published Job flow and send you link below. Let me know if you unable to access it. http://picasaweb.google.com/sarathit/Datastage#5444279384738266178 Use Copy stage , Instead of writing the CSV file directly and get anither link from copy stage to Join. Now you can edit the Metadata in the ...

Hi, I have one parallel job in which is common for two processes. Depending upon process name there are two flows inside it say A and B. Now if process name is A it generates XML file and if process name is B then it generates seq file. Can you provide the Job Design and stages deployed. So that ev...

Hi, I have one parallel job in which is common for two processes. Depending upon process name there are two flows inside it say A and B. Now if process name is A it generates XML file and if process name is B then it generates seq file. Can you provide the Job Design and stages deployed. So that ev...

How can we done the Unit Testing on datastage Jobs.[/b] This is a question for your Lead! and it depends on your project and Client General Steps : 1.Collect the Job list 2.Get the Expectants (i.e Creation of Dataset, Updation of table ..etc) 3.Compare your actual result 4.Provide the status (Pass/...

Please give details about your job and the stages used, so that every one can understand the situation

You can try this

viewtopic.php?t=127835&highlight=Phanto ... CODE+%3D+3

It was discussed earlier, search before you post!!

Try this,