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?
Will it extract record by record from source through network 100 times?
Is this has anything configuared in Powercenter Admin console ?
All the results from the query will be cached by Informatica and processed in blocks depending on buffer/cache sizes. So the Source Qualifier will not query the database 100 times, but only once.