| |
GeekInterview.com > Tech FAQs > Abinitio
| Print | |
Question: 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?
Thanks
|
| February 02, 2007 03:49:40 |
#1 |
| mahendra patnaik |
Member Since: Visitor Total Comments: N/A |
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 |
| |
Back To Question | |
