Odi - LKM Teradata to Oracle

[gpereira]

Hello everyone, everything good?

I am starting with ODI and I am kind of (not to speak completely) ignorant in the subject.

Let's go, I have a project where I will hold ETL loads of a Teradata Base for Oracle. Studying ODI I saw that he has his km (knowledge modules) for various purposes, one of them integration between database technologies.

However, it does not come to the installation of ODI the LKM "Teradata to Oracle".

Can anyone help me? Is there this LKM ready? How do you develop it?

Hugs.

[Trevisolli]

Brother, blzinha?

I am a beginner too, I am in a project of ETL (ODI) about 3/4 months.

For the little I read, in the courses I made, you create a new LKM is a half risky step (I believe!) ...
What I would give to be done, It would be to import an LKM, copy it and, move on this altered ...


However, in this case, I would try to use the LKM: LKM SQL to Oracle .

Do your mind and try to use this there on your floor, to see if it works.

I believe it should work (if the Teradata utilizes the ANSI-92 standard) and, in last case, you could make a copy of it and make the necessary adaptations.

Needing, we are there!

[gpereira]

Thanks Brother!

Funfed with SQL to Oracle ..

I do not know of some feature will be limited .. but .. ta funfando ..

99] Hugs.

[Trevisolli]

BLZY BROTHER, BACAN.

I believe it will not limit no, but, what can do, is to take a look at the load date generated, see if the performance plan is legal etc, comparing with Banco Téadata.

What can help, count on me.