Abinitio Interview Questions- Null key to component


Abintio Interview Question: 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.

Thank you for reading, pls keep visiting this blog and share this in your network. Also, I would love to hear your opinions down in the comments.

PS: If you found this content valuable and want to thank me? 👳 Buy Me a Coffee

Subscribe to our newsletter

Get the latest and greatest from Codepedia delivered straight to your inbox.

Post Comment

Your email address will not be published. Required fields are marked *