Explanation:When using parallel pipelines (see points #8 and #10 below), it provides a high-speed, shared cache. 4. Which of the the following steps should be carried out using data types in SSIS for efficient results ?
A. Make data types as wide as possible so you will allocate more memory for your transformation.
B. Do not perform excessive casting of data types
C. Do not watch precision issues when using the money, float, and decimal types
D. None of the mentioned
Answer:A
Explanation:When using parallel pipelines (see points #8 and #10 below), it provides a high-speed, shared cache. 4. Which of the the following steps should be carried out using data types in SSIS for efficient results ?
A. Make data types as wide as possible so you will allocate more memory for your transformation. B. Do not perform excessive casting of data types C. Do not watch precision issues when using the money, float, and decimal types D. None of the mentioned
Explanation:Excessive casting of data typesit will only degrade performance. Match your data types to the source or destination and explicitly specify the necessary data type casting. 5. Point out the wrong statement :