Skip navigation
Contact Us
557 Views 3 Replies Latest reply: Dec 9, 2012 2:27 AM by Santosh Kumar RSS
Currently Being Moderated

Dec 6, 2012 5:48 AM

Extraction of source data

Hi ,

 

Can anyone please clafify my basic doubt..

How source qualifier exracts the data from relational source. ?

 

Assume my source has 100 records. The source qualifier issues an SQL query to the source database.

and database returns 100records(Assume simple pass through mapping).

 

How the data transfer takes place ?

 

Will all the 100 records from source extracted to ETL server and ETL server loads all the data to target?

or

Will it extract record by record from source through network 100 times?

or

Is this has anything configuared in Powercenter Admin console ?

More Like This

  • Retrieving data ...

Bookmarked By (0)