Tuesday 7 May 2019

Iterating over all tables in one db to create Local Folder

Scnario:- My oracle DB Having 100 Tables  and I Want Store That Tables in Local Folder And Create Tablename.csv and Store The Table Information ...

Componenets Usage:-

1.oracle Connection
2.Toracle Tablelist
3.Toracle Input
4.TfileOutputDelimted...

Job Desgin Like Below:-


Toracle TableList Wirte Code Code

Toracle Input Write logic :-

Select Schmena Dynamic




TfileoutputDelimited:-

Write File Name : Path ur director and Global Varabile of T oracle Table List Use Current Table Function...




And Run The Job:-



U can Get The All The File Database To Local Floder Using Single Job.....

No comments:

Post a Comment

Trigger connections in talend use cases

  Trigger connections define the processing sequence, so no data is handled through these connections. The connection in use will create a d...