Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Ab Initio Interview Questions
Questions Answers Views Company eMail

Runtime behavior of Normalize and Reformat

853

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

303

Difference between output_index and output_indexes in reformat

400

Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999

238


Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

Describe the grant/revoke ddl facility and how it is implemented?

529


Mention what is a partition and what are the different types of partition components in abinitio?

498


How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

314


What is the function that transfers a string into a decimal?

539


What do you know about partition and also tell us about partition components in abinitio?

478






How you can run a graph infinitely in ab initio?

579


Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999

238


What is $mpjret?

533


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

520


What would be the next step after collecting the data?

588


What are the six data process products of ab initio (architecture of ab initio)?

487


What do you mean by a transaction file?

538


Describe what the SQL Server tempdb and tlog files are used for?

1691


Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

567


What is the difference between rollup and scan?

980