How will you ensure that the components created in one version do not malfunction/cease functioning in other version?
What data modelling do you follow while loading of data to tables? Also the DB you are inserting the data has Star schema or Snow flake schema?
How does force_error function work ? If we set never abort in reformat , will force_error stop the graph or will it continue to process the next set of records ?
Latest Answer: force_error() fuction will not stop the graph, it will write the error message to the error port for that record and will process the next record. ...
Difference between a phase and checkpoint as far as i know it something related with how temporary files containing the data landed to disk is handled.that is phases are used to break up a graph so that
Latest Answer: Phase is breaking the graph into different block. It create some temp file while running and deletes it once the completion is done.Checkpoint is used for recovery purpose. when the graph is interrupted, instead of rerunning the graph from the start. ...
It would be great if one of you can explain me in brief what is the function of xfr (like what does it do ,where is it stored ,how does it affect ) as i am very confused on thisthank you
Latest Answer: XFR is used for externalizing a transform/function. A function which needs to be reused at multiple places can be created as a common XFR instead of writing the same code again and again. ...
Latest Answer: I think i misunderstood the question ,there are 3 type of parallelisms in Ab Initio , details of 3 types are expalined correctly above with difference. ...
I want to use an Ab Initio parameter to control whether I am in serial or MFS mode. Basically, I will have an $AI_MFS_PARTS variable. If it is set to 1, then we are running serial. If it is set to 4,
Latest Answer: Its always better to use multiple file system instead of adhoc multifiles.So,physical allocation is a good idea for separation of mfs and serial.Say,i have a physical allocation to path1 for mfs and have the m_mkfs //host/abhi/mfs4 //host/delphi/a/mfs4-0 ...
How can I calculate the total memory requirement of a graph?
Latest Answer: When we did some benchmarking we found that it was closer to ~8MB + MAX_CORE (if any) per component and add in the file sizes.Basically, I agree with the existing answer.Just remember, don't use "in-memory" components if you think the total ...
How can I achieve cummulative sumary in AB Initio other than using SCAN component. Is there any inbuilt function available for that?
Latest Answer: There are three ways1) You can use Scan with rollup component2) Use Rollup component 3) You can also use Scan followed by Dedup sort and select the last record. That will solve the purpose ...
I have file containing 5 unique rows and I am passing them through SORT component using null key and and passing output of SORT to Dedup sort. What will happen, what will be the output.
Latest Answer: If there is no key used in the sort component, while using the dedup sort the output depends on the keep parameter.If its set to firt then the output would have only the first record,if its set to last the output would have the last record,if its set ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
