ETL and Data Integration tools - Modern ETL software for everyone

Hi,

How can i extract data from multiple data sources(ex: one database table and one flat file) in a single mapping/job in Advanced ETL Processor?



Thanks in advance,
Navin.

Can you be more specific please

www.dbsoftlab.com/forum/how-to-get-help-today.html

www.dbsoftlab.com/advanced-etl-processor...set-comparisons.html

Mike

Hi Mike,

Thanks for the quick reply

Using reader i am able to extract data only from one source either database table or text file at one time. i want to read the data from heterogenous sources like database, text file, excel sheet and join them and load in one target table (oracle) in a single mapping.

Thanks,
Navin

So you you have table and file and want to do something like this

source table1 and file1

output file

row1 table.field1,table.field2,table.field3,file1.field1,file1.field2,file1.field3
row2 table.field1,table.field2,table.field3,file1.field1,file1.field2,file1.field3

etc

use lookup function

here is online tutorial

www.dbsoftlab.com/online-tutorials/advan...g-lookup-object.html

Mike

Thanks mike. it is working.

my requirement was:

source1: cust table

cust_id, cust_name, loc
100,aa,la
200,bb,ny

source2: text file - tdetails.txt

cust_id, no_transac, total_amount
100,10,10000
200,15,15000


Output:
cust_id, cust_name, no_tansac, total_amount, loc
100,aa,10,10000,la
200,bb,15,15000,ny


I got the desired output using lookup thanks alot.


Thanks,
Navin.