how can you convert 3 way to 7way partitioning in abinitio?
Answers were Sorted based on User's Feedback
Answer / equalizer
re-partition the data to 7 ways using partition compnents.
Of course you would need 7 way MFS, Generally its always
even number than odd, lke 2,4,6,8,10 and so on.
| Is This Answer Correct ? | 7 Yes | 4 No |
Answer / noname
for any change in partitioning,we have to change
the "AI_MFS_DEPTH_OVERRIDE" parameter in .air-project-
parameters file.
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / ramki
For this btr way is to use a grpah.. use three way file as
input and 7way file as output and use pks in between them
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / avijit
One way to do it is to convert the 3-way multifile to serial file.
i/p(MF) -->Merge(Key)-->PBRR-->o/p(7-way mfs path)
| Is This Answer Correct ? | 1 Yes | 1 No |
What do you mean by a transaction file and how it is different from that of a sort file?
Mention some ways for improving performance of a graph?
What is AB_LOCAL expression where do you use it in ab- initio?
Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...
How you can test a dbc file ?
What are the operations that support avoiding duplicate record?
What is standard environment ? How to use in abinitio graph?
Output for sort and dedupsort with NULL key?
How you can create cross joined output using join component ?
How can we test the abintio manually and automation?
what i the difference between the flows of 3 paralellisms
Explain PDL with an example?