AST Consultant

10+ AST Consultant Interview Questions and Answers for Freshers

Updated 2 Oct 2022

Q1. What is data sparsity and how to handle it ? How to avoid dollar tables creation in a loading in ODI

Ans.

Data sparsity refers to the situation where a large portion of data is missing or empty. To handle it, techniques like data imputation or interpolation can be used. Dollar tables can be avoided in ODI loading by using appropriate mappings and transformations.

  • Data sparsity occurs when there are missing or empty values in a dataset.

  • To handle data sparsity, techniques like data imputation or interpolation can be used to fill in the missing values.

  • Data imputation involves estimat...read more

Q2. How to call two load plan in parallel ? And make it wait if needed .

Ans.

To call two load plans in parallel and make them wait if needed, use a parallel step and a wait step.

  • Create a parallel step in the load plan

  • Add the two load plans as child steps to the parallel step

  • Create a wait step after the parallel step

  • Set the wait step to wait for completion of the parallel step

  • Adjust the wait time as needed

Q3. What is direct path read and write in Oracle ? It's use case and pros and cons ?

Ans.

Direct path read and write is a method of reading and writing data in Oracle without using buffer cache.

  • Direct path read and write is faster than traditional read and write methods.

  • It is useful for large data sets that do not fit in buffer cache.

  • Direct path read and write bypasses buffer cache, reducing memory usage.

  • However, it can cause increased I/O and CPU usage.

  • Direct path write is commonly used for bulk inserts, while direct path read is used for full table scans.

  • Direct ...read more

Q4. ODI file wait - how does it work ?

Ans.

ODI file wait is a feature that allows ODI to wait for a file to be available before proceeding with the execution of a task.

  • ODI file wait is configured in the ODI topology manager

  • It can be used in scenarios where a file needs to be processed before continuing with the task

  • ODI file wait can be set to wait for a specific file name or a file pattern

  • It can also be configured to wait for a specific amount of time before timing out

  • Once the file is available, ODI will proceed with ...read more

Are these interview questions helpful?

Q5. How to handle complex file in ODI ?

Ans.

Complex files in ODI can be handled by using various techniques.

  • Use ODI's built-in file handling capabilities

  • Use custom Java code to handle complex file formats

  • Use third-party tools like Apache Nifi or Talend to preprocess the files

  • Use ODI's knowledge modules to transform the data into a more manageable format

  • Use ODI's parallel processing capabilities to speed up the processing of large files

Q6. How load large file in ODI ?

Ans.

Large files can be loaded in ODI using various techniques such as partitioning, chunking, and parallel processing.

  • Use partitioning to divide the large file into smaller chunks and load them in parallel

  • Chunking involves breaking the large file into smaller pieces and loading them sequentially

  • Parallel processing can be used to load multiple chunks of the file simultaneously

  • ODI also supports external tables, which can be used to load data from large files stored outside the data...read more

Share interview questions and help millions of jobseekers 🌟

man-with-laptop

Q7. How does consistent JKM works ?

Ans.

Consistent JKM ensures uniformity in the execution of tasks and processes.

  • JKM stands for Job Knowledge Management

  • Consistent JKM involves documenting and sharing best practices

  • It helps in reducing errors and improving efficiency

  • For example, a consistent JKM approach in software development would involve using the same coding standards and tools across the team

Q8. Pivot command in SQL ? Running total ?

Ans.

Pivot command in SQL is used to transform rows into columns. Running total is a cumulative sum of values.

  • Pivot command is used to aggregate data and display it in a more readable format

  • Running total is calculated by adding the current value to the previous total

  • Example of pivot command: SELECT * FROM table_name PIVOT (SUM(column_name) FOR pivot_column IN (value1, value2, value3))

  • Example of running total: SELECT column_name, SUM(column_name) OVER (ORDER BY column_name) AS runn...read more

AST Consultant Jobs

Assistant Consultant - Heritage Graphics 2-4 years
WSP Consultants India Ltd
4.2
Bangalore / Bengaluru
Assistant Consultant – Heritage Graphics 2-4 years
WSP
4.2
Bangalore / Bengaluru
Assistant Consultant - Utilities 5-10 years
WSP Consultants India Ltd
4.2
Bangalore / Bengaluru

Q9. Difference between different select query

Ans.

Different select queries have different purposes and syntax.

  • SELECT retrieves data from one or more tables

  • DISTINCT removes duplicates from the result set

  • WHERE filters the result set based on a condition

  • GROUP BY groups the result set by one or more columns

  • HAVING filters the result set based on a condition after grouping

  • ORDER BY sorts the result set by one or more columns

  • LIMIT limits the number of rows returned

  • JOIN combines rows from two or more tables based on a related column

Q10. Collection in PL SQL

Ans.

Collection in PL SQL is a data structure that can hold multiple values of the same data type.

  • Collections can be nested within each other.

  • PL/SQL provides three types of collections: associative arrays, nested tables, and VARRAYs.

  • Collections can be used to pass multiple values to a stored procedure or function.

  • Collections can be used to simplify SQL statements by allowing multiple rows to be returned as a single result set.

Q11. Explain plan

Ans.

Explain plan is a feature in Oracle database that shows the execution plan of a SQL statement.

  • It helps in identifying the most efficient way to execute a query.

  • It shows the order in which tables are accessed, join methods used, and access methods used.

  • It can be generated using the EXPLAIN PLAN statement or through tools like SQL Developer.

  • The output can be in either text or graphical format.

Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Interview experiences of popular companies

3.7
 • 10.4k Interviews
3.7
 • 5.6k Interviews
3.8
 • 2.9k Interviews
3.5
 • 790 Interviews
4.1
 • 33 Interviews
3.7
 • 16 Interviews
3.4
 • 4 Interviews
View all

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary

AST Consultant Interview Questions
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter