Sunday, July 1, 2012

SAP BODS Interview Questions FAQs


Company Name


What are SAP R/3 sources?
What is degree of parallelism?
Types of caches in Dataflow?
what is ABAP dataflow?
Complex situations in BODS?
Describe table comparison tranform?
How to capture data, net change data, if there is no identifier flags in source (no dates, no flags etc..)?
What are real time jobs?
What is embedded dataflows?
Types of transforms in BODS?
What is Idoc files?

Scenarios:
1. How to update data through script?
sql('DS_ILX', 'update tab_x set a = /'XXX/' where a is null');

2. Create files based on department? If department numbers are fixed.
Use case transform for each department.

3. Create files based on department? If department numbers are not fixed.



Design type 2 in BODS?
1. History preserve transform
2. Table comparison, map operation, case transform

What will happen if a column removed in sql t/f?
1. Job will not show error while validating but during running or if we update schema in sql t/f, it will fail.

How to call a batch script in BODS?
1. EXEC function

How oracle table values loaded into variables?
1. SQL function

How to use pushdown sql in BODS?
1. To limit data from source/target
2. Reduce the barrier between source/target to BODS

What are date types available?
Date
Datetime
Timestamp
What are the available memory types in data flows?
1. Pageable
2. In Memory
The software provides the following types of caches that your data flow can use for all of the operations it contains:
  • In-memory
    Use in-memory cache when your data flow processes a small amount of data that fits in memory.
  • Pageable cache
    Use a pageable cache when your data flow processes a very large amount of data that does not fit in memory.
How to import data from table in datastore?
1. Import table by giving owner name



How many types datastores in BODS?
3 Types
  • Databases and mainframe file systems.
  • Applications that have pre-packaged or user-written adapters.
  • J.D. Edwards One World and J.D. Edwards World, Oracle Applications, PeopleSoft, SAP ERP and SAP NetWeaver BW, and Siebel Applications. See the appropriate supplement guide. 

Difference between parameters and variables?

What are the available lookups and brief about those?
Lookup
Lookup_ext
Lookup_seq

Difference between row by row and cached in table comparison?
Huge (more than 50% source) delta data/net change data, then cached
Less than 20% source data then row by row 

Available flags in Map Operation transform?
Insert, update, delete, discard

What is the use of row limit fetch?
Commit check points

What is hierarchy transform?

What is dataflow audit?

Use of number of loaders in target?

What are SCD?
Slowly changing concept for dimensions only
Type1
Type2
Type3

What are additive and non additives?
This concept for Fact only

What is conform dimension?
Time dimension - Fiscal and calender can be maintained with same dimension
Same dimension for sales fact and inventory facts


Brief about oracle exception? Built in and user defined?

Write an exception to update data when data not inserted?
Exception when unique constraint error exists - Duplicate

Can we do DML operation in oracle function?
Yes

Can we call oracle function with DML operation in SELECT statement?
It throws error

What is the use of user hints?
If table is having multiple indexes, we can suggest which index need to be used.
Parallel option

How parallel hint works?
Based on number of usages

Difference between procedure and package?
Procedure will be locked state when it's using
Package will not be locked



What is incremental load?


How dimensional loading and fact loading will be implemented in BODS?


What are the transforms used in BODS?


What is the use of MAP_OPERATION transform?


What are the components in BODS?
Designer
Admin console
Server Manager
Repository Manager
License Manager
Metadata Manager
Locale Selector


What is the types of variables?
Global Variables
Local Variables


What is the use of parameters?


Types of error logs in BODS?
Trace
Monitor
Error log


How to improve performance of a job?


How to identify long running dataflows in a job?


How to improve performance in BODS?
Lookup Caches, Join Ranks








17 comments:

Unknown said...

hi this is shiva kumar.i like to thanks you for sharing available information sap-bods

rav said...

Hi Shiva Garu,
Thanks for your valuable Information
keep Rocks
Would you Provide your mailadress as i have some doubts on SAP BODD

email:rvkumar43@gmail.com

Unknown said...

hi i will want answers

Anitha's Education Blog said...

Thanks for this great information, could help all the people to have confidence to face the interview. Also for fresher who like to have foot print on this industry can have SAP BODS Online Trainingfrom best trainers in the industry as well could earn salary in dollars.

Packers And Movers Kolkata said...

Packersand Movers Kolkata has spearheaded the pattern of rapid administrations and unloading help. An arrangement of migration whether it's your office or your living spot, moving includes various troubles and issues. Presently moving to an alternate city is totally bothered free when the packers and movers Kolkata is with you.
http://kolkatapackersmovers.in/
http://kolkatapackersmovers.in/packers-and-movers-bartala-kolkata

Packers And Movers Delhi said...

Packers And Movers Delhi prompt moving, relocation and shifting services for people and corporation moving to Delhi and round the India. For Movers Packers Delhi city full target report on supply of revenue and effective Movers And Packers Delhi, contact today 08290173333. We include our network in major cities like Bengaluru, Bangalore, Gurgaon, Hyderabad, Chandigarh, Haridwar, Chennai, Noida, Mumbai, Pune, Jaipur, Lucknow, Patna, Bhopal, Bhubaneswar, Ahmedabad and Kolkata.
http://packers-and-movers-delhi.in/
http://packers-and-movers-delhi.in/packers-and-movers-pahar-ganj-delhi

Packers Movers Ahmedabad said...

Excellent post! I must thank you for this informative read. I hope you will post again soon.Please Visit Our Webpage:
http://packersmoversahmedabad.co.in/
WELCOME FOR SERVICES TO PACKERS MOVERS Ahmedabad
Certain tips for a happening relocation People always should prefer the best service providing corporation and not who are cheaper in cost. This because what’s the sense if they are careless towards your belongings at cheaper price? I think your valuable and precious products are won’t be available if broken once and infect they may be more costly than your whole relocation package. If you think that there are not enough options in Ahmedabad Packers And Movers Service field then you are highly mistaken.Movers And Packers Ahmedabad are sitting online to support you in your search of best packing and moving organization available on your need. With this we ensure that they are trustable and answerable to you for your queries and in case of any damage or late delivery.

Packers And Movers Bangalore said...

really a vry nice blog i really appreciate all your efforts ,thank you so mch for sharing this valuable information with all of us.
MOVERS AND PACKERS BANGALORE act as sign given by you and in this way every movement from our side is dedicated to you. With the unobtrusive components of the most noteworthy associations of the city recorded with us, you can either reach them direct and interest for the free relocation refers to from them or you can approach the enquiry structure joined with us and get refers to from the recorded packers and movers particularly on your inbox or over your phone.
Packers And Movers Bangalore

Packers And Movers Pune Charges said...

Thanks for sharing such a valuable information.Im very thankful to you that you had given me this opportunity to write on this blog
Packers And Movers Pune colleagues put all their experience for the whole technique and include every one of their aptitudes till the whole procedure of pressing, stacking, emptying and setting the obliged stuff to the spot the client
needs
http://thebusinessplace.in/packers-and-movers-pune-to-bhopal

Packers And Movers Mumbai said...

Packers And Movers Mumbai Thanks for sharing useful information for us.I really enjoyed reading your blog, you have lots of great content.
http://packersmoversmumbaicity.in/packers-and-movers-jalna-maharashtra

Packers and Movers Chandigarh said...

i must say you had done a tremendous job,I appreciate all your efforts.Thanks alot for your writings......Waiting for a new 1..Packers And Movers Chandigarh
Packers And Movers Muktsar
Packers And Movers Sangrur

रघु पंडित said...


Movers and Packers Hyderabad
Movers and Packers Pune
Movers and Packers Bangalore

Packers And Movers Pune said...

"Packers And Movers Pune" prompt moving, relocation and shifting services for people and corporation moving to "Pune" and round the India. For Movers Packers Pune city full target report on supply of revenue and effective Movers And Packers Maharashtra, contact today 08290173333.
We include our network in major cities like Chandigarh, Bangalore, Chennai, Haridwar, Pune City, Noida, Mumbai, Jaipur, Bhubaneswar, Hyderabad, Lucknow, Patna, Bhopal, Delhi NCR, Ahmedabad and Kolkata. Compare Top Packers And Movers Pune charges to save your money. We present you Best Local Shifting Relocation and Movers And Packers Pune Service Provider.
Packers And Movers Pune
Packers And Movers In Pune

Web Design Company In Bangalore said...

With the help of a single Internet resource you will be able to find an affordable moving solution without having to search through pages after page of search results. Make a list of the preferred moving companies.
Packers and Movers in hbr Layout

Referral Code - Refer and Earn said...

[SAP BO] - Interview Questions Available For Technical Interview !!
Collection Of All The Top Most Interview Questions Asked In Top IT Companies !!
To Visit Click Here - https://www.instamojo.com/interview_questions/

Referral Code - Refer and Earn said...

https://www.instamojo.com/interview_questions/

Interview Question Bank said...

SAP BODS 250+ Interview Questions With Answers - Click Here - https://www.instamojo.com/interview_questions/sap-bods-interview-questions-answers-asked-i/?ref=store