Ab Initio Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Ab Initio Interview Questions

Questions Answers Views Company eMail

What do you mean by the term data warehousing?

1033

Do you think effective communication is necessary for data processing?

1175

Is data warehousing different from data mining?

1053

How data is processed and what are the fundamentals of this approach?

1103

How scientific data processing is different from commercial data processing?

1039

What would be the next step after collecting the data?

1157

Give one reason when you need to consider multiple data processing?

1126

We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

1288

Have you ever encountered an error called “depth not equal”?

1122

Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

1009

What do you mean by a transaction file?

1187

Difference between informatica vs ab initio?

1258

How transaction file different from that of a sort file?

1366

Mention what is abinitio?

960

Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump

1 4756

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

Do you think effective communication is necessary for data processing? What is your strength in terms of same?

1100

Explain data flow graph with an example?

1076

what is the project environment(for each project the environment is same or different to different project)?

2173

In abinitio, what types of parallelism are used?

1039

What are the different types of parallelism used in abinitio?

1059

What are the different types of partition components in abinitio?

1309

What dedup-component and replicate component does?

1232

What do you mean by a transaction file?

1187

How you can run a graph infinitely in ab initio?

1504

What is is a data flow graph?

1076

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

1209

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1960

can we perform checkin and checkout through sandbox?

1140

What is the syntax for m_dump in abinitio?

1588

Explain what is sort component in abinitio?

1060

For More Un-Answered { Ab Initio } Questions Click Here