DSXchange

Any updates on the issue?

Hi, Please find the simple design. Oracle connector--->Teradata Connector I am reading oracle table data which is very huge like say 10 million data into the Teradata using Bulk mode to process the data within seconds. With Immediate mode the above job ran for 4 hours. So went for Bulk mode Details:...

Hi, I have a requirement while loading the file. The below file is semicolon delimiter & Double quote for character fields. I/p: 1000;12-11-2000;"";"ASDDIK";"R" 1001;12-12-2001;"";""TOMI"" ";"R" 1002;01-01-1982;"&quo...

I have a Scenario: Input(text file): ID VALUE CODE 01 1000 DED 01 1000 DED 01 1000 DEP 01 1000 DEP 01 1000 INN 01 1000 INN 02 2000 INN 02 2000 DEP 02 2000 INN 02 2000 DEP 03 3000 INN 03 3000 INN 04 4000 DED 04 4000 DED Output(table): ID VALUE CODE 01 1000 DEP 02 2000 DEP 03 3000 INN 04 4000 DED Outp...

Thanks Ray.. the logic is working..

Any updates for me Ray?

Sorry that i have mentioned a wrong code. Right code is this. Ereplace(Ereplace(link.Eiand,"oeiro","F",-1,0),"kdojke","G",-1,0) I am giving this Ereplace Condition in LOOKUP3 and if link.Eiand = oeiro then 'F' or kdojke then 'G' because from LEVEL column i am ...

My Job Design: ODBC CONNECTOR(B) | ODBC CONNECTOR(A)--->LOOKUP1---> MATCHED1 ODBC CONNECTOR(B) | | | UNMATCHED1 FUNNEL1 --->LOOKUP3--->ODBC CONNECTOR(C) | | | ODBC CONNECTOR(B)-->LOOKUP2--> MATCHED2 UNMATCHED3 | | UNMATCHED2 ----------->FUNNEL2--------> ODBC CONNECTOR(D) I have a columns in A table ...

Thanks Ray.. Its working now with the first approach..

My Job Design: Table(A)-->Transformer-->Table(B) Table A have column NIVA and its values are fsdidkg,kdikkd,joejut and i need to replace those values with G,F,F. fsdidkg = G kdikkd = F joejut = F I have used ereplace and convert functions but i could able to change only G or F, If i am using more er...

B(table) | A(table)--->Transformer ---->Join Stage(fullouterJoin)------>Transformer -------> Matched | Unmatched from B(Tfm) Above is my job design: Table A contains 10 columns in which 5 columns combination gives a key column (ID). My 5 cols are numbers(Oracle DB) when imported the metadata is dec...

I have resubmitted the post and I hope it is able to understand, now i did a test job for the matched output and i am able to get the correct count(4710). How I did it is I have taken the unique constriant combination of Table A after transformer(after Join) I kept Sort and filter it with 1(cluster ...

Hi, I have a requirement as below B(table) | A(table)---Join Stage(fullouterJoin)-------------> Transformer ----------> Matched | | Unmatched from A(Tfm) Unmatched from B(Tfm) I have 10 cols in A in which 5 cols should be merged to create a key(ID). I have 6 cols in which 1 column is key(ID). I am g...

We are the one who created tables for our project so I couldn't able to find out any differences in the datatype so I tried executing with ODBC Enterprise Stage and it worked well. The problem is why ODBC Connector is not able to run and load whereas Enterprise can?

Thanks for the quick reply Craig.
There is no change in the metadata between Staging and Work tables..
Can i know what is Codeset issue?