Abinitio Interview Questions

This group is designed for posting Abinitio tool related interview questions.

Recent Posts

Please share this link to people who are preparing for the abi interview:
https://t.me/abi_interview_qstn

For any queries and new questions submission email us at
[email protected]
Or join below discussion group:

https://t.me/joinchat/WQOCmz10PtNajoum

We will try to add new questions whenever find something new, please keep visiting this group.

Struggling for any new scenarios based questions then write your questions in comment of this post.

Live stream finished (59 seconds)

Live stream started

Channel photo updated

Struggling for any new scenarios based questions then write your questions in comment of this post.

Q153. Which parameter we have to change to execute sub-plan in concurrent or sequential manner.

Q154. How to use continuous flow task component?

Q155. How to run the same plan again and again(calling same plan in loop).

Some questions on abinitio plan
Q143. Which all components in plan?

Q144. What is use of signal event?

Q145. How to run multiple pset through plan?

Q146. What is subplan? How to iterate it?

Q147. Which all loop type available?

Q148. What is ab loop concurrent variable?

Q149. What is difference between plan pset parameter and subplan pset parameter? Can we use or override plan parameter in subplan parameter?

Q150. How you will add start script or end script to graph task component?

Q151. How to call shell script in plan and some arguments?

Q152. When to use Wait for file and what will happen if file doesn’t arrive?

Q139. In input dataset i am having 100 records. I want records between 50-75 and i don't want to read 5th number record.

Q140. What is the main difference between max core and max memory. Where we use this commonly?

Q141. Have you ever encountered an error called "depth not equal"? How to resolve it.

Q142. How you will add default transform rules?

Q138.
I/P
A
B
C
D
O/P
A
AB
ABC
ABCD
Suggest best approach.

Q137. How to append header and trailer in a file using just reformat component?

Q136. Questions:
Input String: abc1234ghj
Expected Output:
3 strings - abc
1234
ghj

Q135. Need to join 2 files as per below cases. will i get the o/p as expected?

i. If file1 and file2 sorted with A,B,C and joined on key A,B

ii. If file1 and file2 sorted with A,B and joined on key A,B,C

iii.If file1sorted with A,B and file2 sorted with A,B,C and joined on key A,B,C

iv.If file1sorted with A,B and file2 sorted with A,B,C and joined on key A,B.

Abinitio Interview Questions pinned «Please share this link to people who are preparing for the abi interview: https://t.me/abi_interview_qstn For any queries and new questions submission email us at [email protected] Or join below discussion group: https://t.me/joinchat/WQOCmz10PtNajoum…»

Guys share the below channel link to others, it will help them get their desired job.
https://t.me/abi_interview_qstn

Do share your reviews or new questions to us at
[email protected]

Scenario Questions

Q130. If max core of sort is 1GB and file size is 150 MB which needs to be sorted then how many temporary file will be created by sort component. Please answer with proper explanation.

Q131. How to achieve headers and trailers process without using next in seq and dedup ?

Q132. In input file there are 100 million records and you want to create 100 sub files with 1 million in each file. How you will achieve this?

Q133. I have a problem scenario. Pls help

I have a ip file like

1 100 null
1 null 200
2 null 100
2 200 null

And op will be like

1 100 200
2 200 100

How to achieve this??

Q134. I have a multiple with 1 million records but in output i need only first 50 records. MFS depth is 8 way and I don’t want to use component in serial layout or to use any departition component. Let me know how to achieve this?

Tip 26:

Perform the following steps to move your code from DEV EME to PROD EME.

1. Save the Graphs.

2. Checkin the Graphs and other necessary objects (dmls, xfrs.......). This will put the updated things in the EME.

3. Create a tag (say xyz) for the graphs / dmls / xfrs that u want to move to other EME. Use the command

air tag create abc /Projects/DEV/ENV/mp/load_dw.mp

4. Create a .save file using the commmand --

air save <.save file name> -from-tag .

5. Load the .save file in the PROD / QA EME using the following cmd -

air load -relocate .

example --
air load xyz.SAVE
-relocate /Projects/DEV/ENV /Projects/PROD/ENV

6. Now checkout the promoted tag using below export command

air project export -basedir -from-tag abc -exclude stdenv

Here abc is the tag name which we had created in step 3

Abinitio Interview Questions pinned Deleted message

See more posts

View in Telegram