Abinitio - Ab Initio Interview questions compiled. Someone please answer them. It will help all of us here.1) W

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Go To First | Previous Question | Next Question

Abinitio | Question 133 of 196

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 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.

Total Answers and Comments: 1

Last Update: November 08, 2008 Asked by: ss

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 07, 2008 04:58:43

ravula sudheer

Member Since: October 2008 Contribution: 7

RE: 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)

I am sending some answers which I know. Hope this is helpful to you ..

1 a) cfg is the databse table configuration file dbc is the data base configuration file.
2.1 databsae component have the cfg file .
2 a) compilation errors are depth not equal data format error etc...
3 a) depth error : we get this error.. when two components connected together but does't match there layout .. at that time we get the depth error..
4 a) start the process all over again
5) partitions are broadcast pbyexpression pbyroundrobin pbykey pwithloadbalance
all
partition component are partitions the data
6) join the data after applied the join conditions unused records are send to the unused port used records send to the output port..
7)muiltifile system : we get the files in different servers..
m_mkfs in this manner we specify the multifile system ...
8) in sandbox we store the graph related files ...its a local work area...its created in local desktop machine...sandbox works as a
intermediate stage between the gde and eme.....
9) we use eme for version control... or pvcs. some times we store the graph with out version control....
10) to increase the performance of the graph using phase & cp sort components...
11) all ready i mention in answer 2 u can check it..
12) upto now i am not involved in production support...
13) eme is a enterprise meta data environment ..eme performs version control statistical
analytical dependency analysis...stores the graph in eme using check in process..
14) delta table maintain the sequencer of each dt...master table is a when we create any view on table that table its called as a master table .or base table ...
15) what error
you got i will tell you the solution on that..
16) partiton by key its used to the
partition the data on key specifier. according to key specifier partition the data ..partition the round robin we used record independent parallisam .. well balanced data
17) scd 2 & 3
18) rollup
component becoz its performs aggregate functions like
19) above answer
20) rollup give summarize groups of data records & performs aggregate functions like
scan generate cumulative totals . to generate year to date totals at that time scan we used..
21) packages
nothing but multistage components or transform components ..
22) we r not specify any record required parameter in
natural join ..
23) partition the data according to given expression at that we use the
by expression
24) adhoc file system is nothing but a set of serial files having the same record
formats.. or set of partitions of serial files ...
25) its depend on writing script
26) ksh represent a script file extension
27) api &
utility mode
28) reformat performs the deriving new data by adding fields
dropping fields redefine format using for rename fields

Hope
this answers will be helpful to you
sudheer
9884039142

Is this answer useful? Yes | No

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof

Is Career Change The Answer To Your Success?

Personal careers are always a critical aspect for anyone. A career path is not easy to abide by, considering that there will always be external factors such as that of new occupations and job openings of another field that people would want to consider.  There are varying factors that can

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi

HR Interview - How To Prepare For Your HR Interview

How To Prepare For Your HR Interview Before you begin thinking about how you are going to dress for the interview it is important to do your research first You should learn everything you can about the company you wish to work for When you have detailed information about your employer you will conve

HR Interview - Telephone Interview Etiquette

Telephone Interview Etiquette When you conduct a telephone interview for a job it is important to show the proper etiquette Not only is it important it is critical is you wish to be hired by the company There are a number of things you will want to do and other things should never be done mosgoogle

HR Interview - How To Succeed At HR Interviews

How To Succeed At HR Interviews There are a number of things you will need to do in order to make sure you pass the interview process Your appearance is something that you will want to pay close attention to Even if you feel that your appearance shouldn t be a factor in whether or not you re highere

HR Interview - Do's and Dont's in a HR Interview

Do s and Dont s in a HR Interview There are a number of things that you will want to avoid during the HR interview process While some of these things are directed at the interviewer the other things are directed at the applicant If interviewers fail to follow the proper procedures throughout the int

Related Categories

—

User Name		Remember Me?
Password

Question Bank