DSXchange

Yes I am doing the internal sort

Hi I am reading the data from file and my requirement is to use merge stage. I need to validate the file aganest two refference tables. so I took the merge stage then I have connected the input stage to the merge and selected the key columns. Then added both reference tables to the merge. Job gets c...

rameshrr3 wrote:will this work for you ?

Code: Select all

If IsNull(string) Then SetNull() Else StringToDecimal(string)

This is not working Still I am getting 0 into table

Hi, I have one decimal column wihc is nullable deciaml(9,2). My source is flat file and this column is comming as null. So I am reading this column as varchar and in the next transformer I am doing the StringToDecimal(string) and loading into table. But in the table it is loading as 0 (zero). I want...

Hi , I have file with 4 columns. one of the column is notnull and length is 12 char. But sometimes null value may come to this column. So while reading I am making as varchar and nullable yes in the file and reading. I want to reject that record while loading into database. I am using constrain, IsN...

Hi ,
I am reading a pipe delimited file which contain ID and description cols.

ID is char 4
description varchar2(30)

while reading a file it is erroring out as ID delimiter is missing.

If I changed to char to varchar , it is reading well.

Can any one help me why I am getting this issue.

Thanks for your reply. I don't want to decript again, my requirement is I have 5 systems, out of wihich , the key column should encript, (meaning end user should not find out this id is from particular system. ) We are loading 5 systems information into one datawarehouse. to deidentify the key colum...

Hi I need one quick information regarding check sum stage. I want encript one of the key field. To make distinct and uniq out of given values, I am using two columns and passing those two columns through check sum stage. The result I am getting 32 numbers. But I need 15 to 16 numbers only. I dont wa...

Hi I didn't receive any reply for my email. In datastage 8.1 or 8.5 we are using connectors . So which way is best for loading data into teradata table.

so what would be the difference between using connecters and using script for loading/miving data into files.

update the licence info.

Hi I will get daily files which will be 2 mil records and we laod into teradata. Next day we will use as reference for next day. This process will reapete daily. My question is about performence which way would be correct 1. loading the daily files into working tables and compare with target or 2. d...

All columns are the varchar data type. And the DS server is on windows. As I said I don't know if the language is UFT-8 getting success but data is not matching.

Hi,
Can any one please help me on this. I didn't get any solution as of now.

Hi I am using ftp stage and loading the data into seq file. The same configuration is working for the other jobs. But for this job it is not working I am getting the following errors. Test_sample..Transformer_12: Internal error: function 'utf_to_row()' failed Test_sample..Transformer_12: Function, c...

Hi All, I am loading data into AS400 table from oracle stage. we have journaling is on onthis table. Job is aborting with the following error. "VPMDATA,0: Fatal Error: Fatal: [IBM][CLI Driver][AS] SQL7008N REXX variable "VPMDATA " contains inconsistent data. SQLSTATE=55019 DSTAGE-DB2...