DSXchange

My source length is bigger than Target.I have 241 columns. The datalength for all the columns is greater than target length.

My source length is bigger than Target.I have 241 columns. The datalength for all the columns is greater than target length.

My Sourcedata is Varchar and Target data is Decimal. I am using stringtodecimal(col1) in the Transformer.I get the following warnings."Conversion error calling conversion routine decimal_from_string data may have been lost" .

Can anyone please help me how to get rid of this warning

I am loading data from a zip file to Teradata multiload stage.The multiload has completed.I can see the data in the table but the job gets aborted. At the end of the report file I see this.
Highest return code encountered = '3807'.

Can any one please help me.

I have a source which is a zip file. I have to copy the data from source to target.I am using gunzip filename in before job subroutine and then reading the file. If the file is too big the job gets aborted with error "File is too large". Is there any other way to read a zip file?.

it does not allow

I have to write a query in Teradata one of my table is empty. select count(*) as counts ,'sourcename' as src_name from table1 if the table is empty it returns zero rows. I want my output to give me 0 sourcename is there any function which will force the values 0 and sourcename.I tried zeroifnull tha...

If I take the constraint out the job gives me the warning "Field Recordscount from input dataset '0' is NULL. Record dropped." I thought the lookup stage will check for the key match from the source xxxx MI 2007-06-07 and from the reference xxxx MI 200 and gives me output xxxx MI 2007-06-0...

I am sorry This is how my data is. sourcename state load_dt xxxx MI 2007-06-07 xxxx WI 2007-06-08 xxxx CA 2007-09-07 sourcename state Recordscount xxxx CA 100 xxxx MI 200 xxxx WI 200 sourcename and state are keys. does records in the State column need to match order?.

my source is teradata table. my target is also a teradata table. I have to do lookup get the related records where there is key match. My source has 3 rows.and my look up table has 3 rows. source data State sourcename Records MI xxx 100 WI yyy 200 CA zzz 555 LookupData State sourcename Loaddate WI x...

I have a date column in source.The data type is for this source date column is date.when I write it sequential target file whose datatype is also date.I get the following warning
APT_CombinedOperatorController: Conversion error calling conversion routine date_from_string data may have been lost

I have a Date column in the source table . I am doing a look up with this datecolumn in my source table with the Date column in another table. Both are in same format. As of know I have no warnings or errors. will I get any warnings in future production runs?.

Thank You

I have two tables. Current and previous.I am joining these two tables and writing it a Sequential file. The table definition for the two tables is same. I am getting the following errors Join_Stage: When checking operator: Dropping component "column1" because of a prior component with the ...

Thanks for the help