Ab Initio Data Warehousing Question:
Download Job Interview Questions and Answers PDF
How do you convert 4-way MFS to 8-way mfs?
Answers:
Answer #1To convert 4 way to 8 way partition we need to change the layout in the partioning component. There will be seperate parameters for each and every type of partioning eg. AI_MFS_HOME, AI_MFS_MEDIUM_HOME, AI_MFS_WIDE_HOME etc.
The appropriate parameter need to be selected in the component layout for the type of partioning.
The appropriate parameter need to be selected in the component layout for the type of partioning.
Answer #2You can change partition from 4 way to 8 way by re partitioning. Repartioning can be done by changing the partiton to all to all and then providing the layout as 8 way to the partitioning component
Download Ab Initio Interview Questions And Answers
PDF
Previous Question | Next Question |
Have you used rollup component? Describe how? | What is AB_LOCAL expression where do you use it in ab-initio? |