DSXchange

My design,

TargetTable(Reference)
|
|
V
SCD ----->ODBC Enterprise Stage
|
|
V
Dataset (Insert)

My apologize, I was using Upsert Mode --> Insert than Update

It should have been Update than insert.
My target was Terdadata database

Its working now, thank you

Thanks for the reply, First time my record is as below, EMPNO ENAME ADD SALARY CURR_IND 10001 John Doe Singapore 4000 Y I changed SALARY from 4000 to 500, in my source. When i run my job iam getting 2 inserted record i.,e SKEY EMPNO ENAME ADD SALARY CURR_IND EFF_DATE 85 10001 John Doe Singapore 4000...

Hi, My design is as below TargetTable(Reference) | | V SCD ----->Dimension Table (Upsert) | | V Dataset (Insert) In the Dim update tab Empno Business Key Ename Type2 EAdd Type2 Salary Type2 Curr_Ind Current Indicator (Derivation Y, Expiration N) Empno Ename EAdd Salary Curr_Ind 555 RELIC GERMANY 121...

Hi, Thanks for the reply, (i have 1 source and 1 tgt table, comparing) SRC Columns EMP_ID EMP_NAME EMP_ADD SALARY TARGET Columns S_KEY (surrogate_key) EMP_ID (Business_Key) EMP_NAME EMP_ADD SALARY CURR_IND (Current Indicator) EFF_Y (Effective Date) EXP_Y (Expiration Date) Job Description TGT | | SRC...

Hi guys, Iam need to implement a SCD Type2 in DataStage 8.0, Need to know what are the important fields i should take to find out how it works. I just need to know how this SCD works in 8.0. DEPT_K (Surrogate Key) DEPT_C (Business_Key) From where should be the below fields value come from. Type2 Cur...

Thanks, Can you please give me more details with regard to shell script, how to pass the 2 parameters inside shell script

Thanks, for the reply

1st job
I have a datastage job where i will do some processing and get 2 columns, deptid n dname.

2nd job
Based on the above 2 columns i need to delete 23 tables i.e., where condition.

How to do that in BTEQ or shell script.

Thanks

Hi,

I have a requirement like based on condition i need to delete the rows from 23 teradata tables, any ideas please. (from single job).
It will be run once in a year.

thanks

Can you please elaborate more, not able to get any idea..

DATASET--> COPY-----> 2 links>
1 As it is
2 Sort-->Aggr> Join-->1---->Dataset

Before posting this issue i already did search in this forum.

But I didn't find any posts related this issue.

Thanks,
Srini

Hi Ray,

I am getting this warning in Transformer stage.

TRNS_FDI_DATA,0: Invalid character conversion found converting to ISO-8859-1, substituting.


Thanks,
Srini

Hi, Loading source data [Sql server] to Teradata as target database. Extracting data from Sql server using Dynamic RDBMS stage. Source containing one description column length as 4000 chars. This column contain data as multiple language values. NLS MAP ----- Project default (ISO-8859-1) I am getting...

sorry guys for coming late, StringToDate(Right('00':MONTH,2) : "/" : right('00':DAY,2) : "/" : Right('0000':YEAR,4), "%mm/%dd/%yyyy") Thank you, all you guys for your support, when i execute the above statmenet it gives like 2008-02-19. Again later i changed that by usi...

I tried the option like
StringToDate(MONTH : "/" DAY : "/" YEAR), "mmm/dd/yyyy"), but in vain

Hi,

My Source column all are Integer
Target column is Date (format)

My incoming values are like MONTH, DAY, YEAR. (3 different inputs)

Iam giving like MONTH : "/" DAY : "/" YEAR

I want the output as 12/31/2008, its giving error

Any ideas, please

Thanks