sorry.. I missed the above comment somehow.. I have not worked in ODI since 2018.. is there any specific topic you want video on

thank you bhai..

sorry.. I left ODI back in 2018.. I created one small ETL Framework for my organisation.. but these days we all use Kafka or Some other services

yes .. this is the reason why I made these videos.. as I was having struggle to find good videos as well.. that is why I thought of making these..

Hi Jose, How about creating a procedure for this purpose and then call the procedure before loading of the file..

@@amitmaindola Do you have and example of the command that I should execute on the procedure to convert Ansi to UTF8 for the csv? Regards and thanks for your help

@@JoseFernandoOrdonezA There are sevral ways to do it. 1) Based on your server os you can invoke the command 2) you can create script in jython/python/java to change the format of the file.. this will be preferred way. A simple google search can show you the code you need.... I have not touched ODI since last 4 years so I cannot show you it in my screen but this kind of requirements are simple only and code can be found out in google easily .. . Below you can see one such example .. hope it helps you www.codegrepper.com/code-examples/python/python+ansi+to+utf8

github.com/maindolaamit/ODI_tutorial

Updated in the Video description as well.. thank you

Sorry for low voice, I am an amateur in Video creation and was speaking cautiously for the video. Voice over indeed is an art behind good videos; will implement in the next series.

@@amitmaindola do you teach odi

@@a2zofficial645 Not as such professionally but on demand can opt for it.

@@amitmaindola i want to learn

@@pankajthapa5718 At what level do you want to learn, Beginer or Intermediate. For begineer level I would suggest to watch some of the existing videos to devleop your foundation about tool. You can drop your queries to me for additional information at [email protected]

Aapke internet speed per depend karta hai

Done buddy... It was first time I drove off the road

Video main dikha rakha hai

Samjha nahi

If requirement is only to move file you can use the ODI Procedure .. if extra operations to be performed like zip and move and then update audit table you have to use your own custom logic.. either via OS Command or you can create a python procedure and use it after file load

ek baar uninstall kar k dobara se install karna

Sure I will create another video session on the same

thank you buddy

@@amitmaindola if we need to load two file directories into a same mapping how is that process looks like ?

@@sandeepobiodi341 Create the two File Models with different logical and physical schema pointing to source directories, drop them in the same mapping and you can apply joins if there are any

@@amitmaindola I understood this I want to know the process interms of the pkg how does it change and in terms of jython script how does it change

I mean right now we are adding it as category name as EMP what if I have DEPT tables in the same directory how can we make it as dynamic ? based on file name ?

Android version ?

Tarika same hi hai ... Google Indic Keyboard install karna .. phir settings main jaake enable karna hai

@@amitmaindola ji android hai

will be same.. you need to goto Langauage and Inputs

Thank you

Ravi Sg baat karne wali ladki se live telecast online baat kare Hindi mai

On the Way