Answer Detail: RE: Session Execution

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Print |

Question: Session Execution

Answer: What is the first one executed in a session? Is it the Truncate Target Table option or the Post SQL? Explain

October 10, 2008 15:56:20	#2
Mamta11	Member Since: July 2008 Total Comments: 12
RE: Session Execution
Truncate table will be executed first. Trunc. table gets esecuted before the table starts loading and post SQL executes after the session is completed (table loaded)

Back To Question