How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1135

How and where you used hash file?

1184

Explain when do we analyze the tables? How do we do it?

1006

What are the difference types of stages?

1223

what are the others of "bad files" and "discard files" when using sql*loader?

2141

What is difference between server jobs & parallel jobs?

1052

10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?

2509

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2047

What are the different forms of output that can be obtained after processing of data?

1264

What are objects?

1026

How will you create report from two subject areas

839

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2053

While creating table my dba has fallback or no fallback in his ddl. What is that?

1193

How can you communicate with web server (apache or iis) from coldfusion?

1126

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1069