 Related Questions Latest Answer : Rollup summarises the group of data records based on key eg you want the income of a particular city from a set of records , you can use the rollup component.example dml is customer ,city name and amount (here the key ... Latest Answer : Foreignkey is a primarykey in other table which has parent & child relationship betwee two tables. foreignkey resides in child table which reference the parent table. ... What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summirize group of data record. then where we will use aggregation ? Latest Answer : roll up generates data records that summarizes group of data records the rollup can be used to perform the data aggregatuin like sum,avg,max,min etcScan component generates a series of cumulative summary records such as successive yera to date totals ... Read Answers (3) | Asked by : SG For data parallelism, we can use partition components. For component parallelism, we can use replicate component. Like this which component(s) can we use for pipeline parallelism? One of the advantages of abinitio over other etl tools is better error handling..how can you say it provides better error handling. We have sort and sort within groups components. we can achieve the sort within group functionality by palcing two keys in sort group. then why i go for sort within gropus? Ab Initio Interview questions compiled. Someone please answer them. It will help all of us here.1) What is the difference between dbc and cfg? When do you use these two?2) What are the compilation errors you came across while executing your graphs?3) What is depth_error?4) During the execution of graph, let us say you lost the network connection, would you have to start the process all over again or does it start from where it stopped?5) Types of partitions and scenarios.6) What does unused port Read Answers (1) | Asked by : ss Latest Answer : pros: easy and save development timecons: need to understand how to feed the parameters, and you can't control it easily :) ... Hello all Ab Initio developers,I have recently graduated and I have just joined the Data Warehousing Hello all Ab Initio developers,I have recently graduated and I have just joined the Data Warehousing profession, I got some basic training in Ab Intio for few months now and have a few questions, can someone please help me. 1) How does parallelism work in Ab Initio? When and how do you decided when to use the different types of parallelism?1. Component -- multiple components running on SEPRATE data at the SAME time.2. Pipe-line -- Multiple components running simultaneously on SAME data at the
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
