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 used? Within the DATABASE layout we also see the SERIAL ,TABLE and EXPLICIT args options, when do we use those? what arethe advantages and disadvantages to this approach? Thanks
How does one make use of the "Call Web Service" component in the $AB_HOME/connectors/Internet directory of the component selectory window of the Ab Initio Console? Explain with Sample Code
Latest Answer : Sort, Sort within group, Rollup will break pipeline parallelism ...
What will happen when we pass dot or invlaid parameters in the inout component layout URL?
How to avoid duplicates without using dedup component?
Latest Answer : We can avoid duplicate by using "key_change" method of the rollup component.
The code will be like below.
out :: key_change(prev,curr)=
begin out :: cur != prev ; end out :: rollup(in) = begin out :: in ; end
...
How does component folding works?
How to calculate the total number of records in the file using REFORMAT instead of ROLLUP?
Latest Answer : Via its log port. ...