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

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 ?

99

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

95

What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

170

How can we increase the loading performance of oracle table in AbInitio?

94

What happens when we provide null key to sort, merge and pbks in Abinitio ?

111

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

73

Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

85


Post New Ab Initio Questions






Un-Answered Questions { Ab Initio }

What is the purpose of having stored procedures in a data-based?

162


What is a cursor? Within a cursor, how would you update fields on the row just fetched?

169


What are the benefits of data analyzing?

211


i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

1129


What are differences between different versions of co-op?

171






Explain data flow graph with an example?

172


What are the different types of parallelism in ab initio?

176


What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

166


What is a rollup component?

163


What information is provided by .dbc file extension for connecting to the database?

171


What is the syntax for m_dump in abinitio?

225


Pdl with an example?

168


How to move or copy the project parameter or project object to my sandbox?

1365


What are the operations that support avoiding duplicate record?

212


What are the factors on which storage of data depends?

189