In SAP BODS, what are the questions asked for a 3-year experienced profile?

1. How to extract multiple excel sheet’s data to single target.

2. How to do dynamic flat file split(Example take EMP table,having kind of deptno’s then split dynamically to different “txt” sheets.

3. While extracting multiple “txt” or “excel” sheets data to single or multiple targets need “sheet name’s” in separate column.

4. How Degree Of Parallelism give performance.

5. learn some important functions like(replace_substr,index,word,word_ext,num_to_interval,interval_to_char,to_char ,To_date and mail_to), will get some scenarios on these functions like how to split 2 word’s name like(dileep kumar) but output should be dileep in one column kumar should be in another column.

6. How to get same output without using “Table_comparison and History_preserving”.

7. When do you go for Data Transfer Transformation.

8. Difference between 4.0&4.1&4.2.

9. Difference between lookup and join.

10. Difference between Merge and join.

11. Difference between SQL and Query and transformation,Which one will go performance,what are the defects in SQL transformation.

12. Performance issue’s.

13. Difficult scenarios which you faced in your project.

14. How to remove special characters(use Costume function).

15. What is truncate option in target table.

16. Error handling.

17. In a single workflow having 10 data flows but should not run some data flows 1st time ,but should execute.

18. Difference between rownum,rank,dense_rank.

19. How do you find that your job is full push down or partially push down.

20. Architecture.

21. Multiple jobs execution at single time.

22. How to generate “.bat” file and the use of it.

They might start from the basics of Data migration. Listing down a few questions that might come up, along with the other questions given by others:

1. The Six tiers of Data migration and their importance (Data extraction, Source specific Logic, Global business logic, pre-load analysis, Load and post load analysis)

2. Importance of a staging repository

3. Advantages of Global business logic over the source specific logic

4. Importance and advantages of validation reports and how to create them

5. Challenges that you have faced in a data migration project previously and how you handled them

6. What are the different objects within SAP BODS that you have used very often?

7. Difference between a Datastore and a Database

8. Difference between a Job and a work flow

9. Different types of jobs in BODS, how and when do you use them?

10. Difference between Local and Central repository

11. Difference between Tables and Template tables in BODS

12. What are the different flat file formats available?

13. What are the different transformations that you have used and at what circumstances?

14. In which transformation do we apply basic SQL transformations like substring, upper, etc?

15. Name few elements in the Execution properties when you execute a job.

16. Importance of Bulk loader option – when do you use truncate and when do you use Append?

I think he can be asked about the different options in the tranfoms depending on the scenario for jobs.

1. What are the differences between rowbyrow select and cached comparison table and sorted input in table comparision transform?

2. What is the use of Array fetch size?

3. What is the use of rows per commit?

4. What are the different strategies you can use to avoid duplicate rows of data when reloading a job?

5. List some of the reasons why a job might fail to execute?

6. Have you implemented full/Delta loads in your project?

7. Difference between table comparison transformations and auto correct load?

8. What is DOP? How is can be useful and how is it is implemented?

And also some realtime questions about implementing the transformations with scenarios