Skip navigation
Contact Us
3463 Views 3 Replies Latest reply: Feb 18, 2013 8:10 AM by Siva Ram RSS
Siva Ram Novice 20 posts since
Jul 11, 2011
Currently Being Moderated

Feb 13, 2013 8:39 AM

Some Interview Questions which needs to be answered

Hi Friendz,


Below are some of the interview quetsion which i have got in an interview:


1. How can you get the 2nd last record using a Rank Transformation

2. How can you process multiple flatfiles of same structure at a time

3.  I want to create a mapping which needs to duplicate the records 10  times. Saying for example if i have 5 records each record should be  duplicated 10 times, what is the approach

4. what is the difference between a Target update override and Update strategy transformation

5. what is the dynamic cache, how it is used and which suitation it will be used ?

6. what is a fullouter join

7. what is the difference between a view and materialized view

8. what is the difference between info 8.x and info 9.x

9. what are the advantages of the service oriented architecture

10. what are the different types of the fact tables available in DW and are the uses of those

11. what is meant by a confirmed dimension

12. what are the advantages of the snowflake schema ?


Request to some anwser these so that i will make a note of the same.


Thanks in advance....




More Like This

  • Retrieving data ...

Bookmarked By (2)