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

 Real Time interview questions:- 1.Write condition in tMap expression builder(i.e.,if the branch is CSE then computer science, IT then Infor...