Question regarding communication b/w ETL server and DB

[saikrishna]

Hi

I have a question on the communication b/w ETL server and DB server for a particular scenario.

Assume that ETL server (DataStage) sits in machine A and DB server (Oracle) sits in Machine B.

I have a job with the following format

DBstage->Tfm->DBstage

DB stage will connect to oracle.
This job is about simple select from Table A and Insert into Table B without any transformations.

Case 1:
---------
With this parcticular scenario, will there be any data flow between ETL server and DB server back and forth.

Case 2:
-----------
If there are any transformations applied to the data from TableA and before we insert into TableB, would there be any data flow between Dbserver and ETL server back and forth?


Thanks
Sai

[ArndW]

Yes, the data will flow through the ETL server in both cases.

[chulett]

Unless you play some games and contain everything within a single stage, data will "flow between" the ETL Server and the DB Server in all cases. And with both source and target db connections in the job, data will flow "back and forth".