Question regarding communication b/w ETL server and DB
Posted: Tue Nov 25, 2008 3:24 am
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
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