Why We Should Use Dac And Not Control All Execution Through Informati

1.	Why We Should Use Dac And Not Control All Execution Through Informatica?
Answer» For BETTER performance management, such as creating index, dropping index, truncating before LOAD. Without DAC a custom ETL PROCESS will be needed, which has to survive the upgrate. For better performance management, such as creating index, dropping index, truncating before load. Without DAC a custom ETL process will be needed, which has to survive the upgrate.

Why We Should Use Dac And Not Control All Execution Through Informatica?

Answer»

For BETTER performance management, such as creating index, dropping index, truncating before LOAD. Without DAC a custom ETL PROCESS will be needed, which has to survive the upgrate.

For better performance management, such as creating index, dropping index, truncating before load. Without DAC a custom ETL process will be needed, which has to survive the upgrate.

Discussion

No Comment Found

Related InterviewSolutions

Difference Between Homogeneous And Heterogeneous Execution Plans?
How Dac Determines Tasks Required For Any Given Subject Area ?
How Dac Handles Parameters At Runtime ?
Explain Index, Table And Task Actions In Dac ?
What Is Authentication File ? If You Have Dac Client Installed Can You Access Dac Repository Without Authentication File ?
Explain Briefly What Kind Of Dac Repository Objects Held In Source System Containers ?
Can We Have Two Dac Server On The Same Machine ?
Does Dac Keeps Track Of Refresh Dates For All The Source/target Tables ?
Let Say You Can Not Use Dac Scheduler To Schedule You Execution Plan. What Other Options Do You Have ? How You Can Achieve This ?
From You Past Experience – Explain Scenario Where Micro Etl Execution Plans Produced Wrong Results On Reports?

Why We Should Use Dac And Not Control All Execution Through Informatica?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment