Tag: databases

Joining two flat files

To join two table from different data bases

To join flat file and relational table

All of the above

Filter

Router

Sorter

All of the above

Insert

Data driven

Update

Delete

Source qualifier, Sorter

Sorter, Joiner

Joiner, Expression

All of the above

It does not contain return port

Executed for every record passed

Works only when lookup function is called

All of the above

Sorter transformation is more faster

Order by clause on database is more faster

Both will take same time

We cannot compare

Lookup, Joiner

Lookup, SQ

SQ, Joiner

None of the above

SQL LOADER utility is used to load data from other data source into Oracle.

For example, if you have a table in FOXPRO, ACCESS or SYBASE or any other third party database, you can use SQL Loader to load the data into Oracle Tables

SQL Loader will only read the data from Flat files.

If you want to load the data from Foxpro or any other database, first step is to convert that data into Delimited Format flat file or Fixed length format flat file, and then use SQL loader to load the data into Oracle.

All the above

sqlldr userid=scott/tiger control=emp.ctl log=emp.log

qlldr userid=scott/tiger control=emp.ctl log=emp.log data=data1.dat

sqlldr userid=scott/tiger control=emp.ctl log=emp.log direct=FALSE

sqlldr userid=scott/tiger control=emp.ctl

Control File

Data File

Target Table

Bad File