Interview Questions in Ab Initio

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 in join component do?

7)Define Multi file system. Can you create multifile system on the same server? Also, if you have a table that has Name, Address, Status, Position attributes, can Name and Address be on one partition and Status and Position in the other partition?

8)What is a sandbox? Did the co-operating system version 2.8 have sandbox, if not how would you store the respective files?

9)How did you do version control? Which tool did you use?

10)How do you troubleshoot performance issues in graph?

11)What are the usual errors that you encounter during ETL process apart from compilation process?

12)Were you involved in production support? What were the different kinds of problems that you encountered?

13)Please give us insight on Enterprise Meta Environment, and some possible questions on that.

14)What are delta table and master table?

15)What error would you get when you use Partition by Round Robin and Join?

16)In which scenarios would you use Partition by Key and also, Partition by Round Robin and differences between the both?

17)What are the different dimension tables that you used and some columns in the fact table?

18)How do you count the number of records in a flat file?

19)How do you count the number of records in a multifile system without using GDE?

20)What does Scan and Rollup component do and give a scenario where you used them?

21)Did you ever used user defined functions or packages? If yes, give a scenario.

22)What do you have to give the value for the Record Required parameter for a natural join?

23)When do you use Partition by Expression?

24)What is Adhoc File System? Give me a scenario where you used it.

25)What are the different commands that you used when writing wrappers?

26)What do the hidden files in a sandbox represent and what does start.ksh represent?

27)What are different things that you have to consider when loading data into a table?

28)What is difference between Redefine Format and Reformat components?

29)Sometimes you have to use dynamic length strings. Can you give me one circumstance where you need it?

30)If you have a flat file as follows:

20 General Manager Chris
30 Divisional Manager Harry
20 General Manager Mary
30 Divisional Manager Dravid
How do you count the number of records that have 20 in the first column, and likewise for 30.