Plz provide comments and suggestions. Thanks in advance.
My question is related to the INPUT TABLE component layout. If we select the layout to be DATABASE- (database default), where exactly is it pulling that layout from? When should this option be used? Within the DATABASE layout we also see the SERIAL , TABLE and EXPLICIT args options, when do we use those? what are the advantages and disadvantages to this approach?
RE: Plz provide comments and suggestions. Thanks in ad...
Unless your database is partitioned you'll see limited use for database-facing layouts. By using the serial option and setting the component's layout to a multifile and using the ablocal expression in the SQL you can cause Abi to initiate multiple parallel instances of the input table and get what you want. Keep in mind that you'll need high connection bandwidth between the machines or you're wasting your time.Advantages and disadvantages are largely a function of your environment- these options are there to help face your system as you already have it or as you want it to be. Practically speaking - these options serve in the extraction process - which you will want to run at the highest speed. So do some testing and see which one runs fastest for you - and make it so.Regards Mahendra
RE: Plz provide comments and suggestions. Thanks in advance. My question is related to the INPUT TABLE component layout. If weselect the layout to be DATABASE- (database default), whereexactly is it pulling that layout from? When should this optionbe us
I would suggest you not to use the default database. either ai_serial or ai_mfs. Default database will pick the data from the database in the same structure as it is in db. The data in db might be serial or partition.
