Can you please help this query. As follows:
Actual scenario: We have two methods to pull up the data from MS SQL Server to BW Server using DB Connect.
1st Method is directly from MSSQL server to BW server.
2nd Method is MSSQL -> Temporary files -> Flat files -> BW server.
Here for easy process and performance we use 1st Option.
So my question is Our client is asking for comparision of both methods and advantages & disadvantages. Process for 1st Option.
Its urgent ...plz help me out..