Ab Initio Data Warehousing Question:

Download Job Interview Questions and Answers PDF

How do you convert 4-way MFS to 8-way mfs?

Ab Initio Interview Question
Ab Initio Interview Question

Answers:

Answer #1
To 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.

Answer #2
You 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 QuestionNext Question
Have you used rollup component? Describe how?What is AB_LOCAL expression where do you use it in ab-initio?