Abinitio Interview Questions- Null key to component

 Overview: This post is about Abintio interview question. Soon will provide a series of Abintio Interview questions, which helps you while preparing your interviews.

What is Abintio ?

Answer: Ab initio is a Latin term meaning “from the beginning” and is derived from the Latin ab (“from”) + initio, ablative singular of initium (“beginning”). Abinitio is a tool used to extract, transform and load data. It is also used for data analysis, data manipulation, batch processing, and graphical user interface based parallel processing.

Let’s head up to more Questions & Answers

Q1- What will happen if we pass null key to join?

A1: If you are passing null key to Join component, you will get Cartesian product of records of both the input ports. For example suppose there are two input ports in0 and in1. So if we pass them to join having null key the output would be Cartesian product of both the input ports (in0 records X in1 records).

Q2. What will happen if we pass null key to scan?

A2: Scan is an multistage component but when you pass a null key to scan it will give all the records as the output

Q3. What will happen if we pass null key to dedup sort?

A3: In case of dedup component if we give keep parameter as first it will give the first record as the output if we give keep parameter as last it will give the last record as the output but when we give the keep parameter as unique it will give no records as the output.

Q4. What will happen if we pass null key to rollup?

A4: If we give null key to rollup its output will have only one record, it will consider all the records as one group. It is useful when we need to count the number of records in the port.

Hope you enjoyed this post. If you have any recommendations, please let us know what you think in the comment section below! See you again next time!

If You Liked It, could you do me a favour and tell your friends !! By sharing it on Facebook, Google+, Twitter.