Monday, June 6, 2011

TCS(white field,bangalore) Interview Questions (4-06-2011)

1.explain  ur project?

2.how to display duplicate records in a table by using sql query?
ex:100 aaa
   100 aaa
   100 aaa
   101 bbb
   102 ccc

i want to dispaly like this 100 aaa
                                     100 aaa
                                     100 aaa

3.explain scd type2 i have the data d1 1 mum
                                                     d2 1 kol
                                                     d3 1 hyd
how it will be inserted?

4.what is mapplet and expalin where u can use mapplet in realtime?

5.emp
  boss
  sales transaction
  hra a/c

in which what are the fact and dimensional tables?

6.explain mapping parameters and variables?

7.what is factless fact table and explain where u can use in realtime?

8.diff b/w in and exist?(sub quaries)

9.i have 100 records in my target table and next day i want to insert 5 records,
and i want to update 10 records then what is tot no.of records in my target table?(by using scd2)

10.diff b/w connected and unconnected lkp?

11.by using which transformation u can capture the rejected records and where it will be stored?

12.what is the shortcut and reusable transformation?

13.in my table 1000 records are there i want to get 100 records what is the sqlquery?

14.diff b/w sourcequalifier and filter?

15.what is abort and stop where we can use abort?

16.what are types of tracing levels and what is the verbose initialization?

17. diff b/w union and joiner?

18. what are the reusable and nonreusabletasks?

19 comments:

  1. pls send me answer it really helpful for me
    pl send on vadnere.harshal@gmail.com

    ReplyDelete
  2. thank you suresh for posting Interview questions. these are very helpful for us...u r doing a great job.

    ReplyDelete
  3. Hi Suresh, Please send the answers to me also.... It will be a great help.
    thanks a lot for the questions

    2princejacobk@gmail.com

    ReplyDelete
  4. Hi suresh, Plz send the answerrs..

    nishu.dwh@gmail.com

    ReplyDelete
  5. Hi Suresh,will please share the answers on my mail id:sanket.khairnar.bi@gmail.com

    ReplyDelete
  6. Please share the answer to my id imthiyas90@gmail.com

    ReplyDelete
  7. Hi Suresh, Thanks a lot for the efforts.
    Please send the answers on iadarsh@outlook.com

    ReplyDelete
  8. Hi It would be really gr8 if you can you post your answers,
    so that all the viewers can be benificial

    Regards
    Rakesh

    ReplyDelete
  9. Hi Suresh,
    Thanks for sharing these questions.Could you please send me the answer also on mail2harilal@gmail.com.

    Thanks in advance.
    Regards,
    Hari Lal

    ReplyDelete
  10. Hi Suresh,

    Please send me the answers for above questions. 2row i am having an interview in TCS bangalore location. Please help me.

    email id : bojanapatipadma@gmail.com

    ReplyDelete
    Replies
    1. pls help me how to prepare informatica stuff for interview i am intrested in it i needajob in thatto play a key role

      Delete
  11. Hi Suresh,

    Please send me the answers for above questions. tomorrow i am having an interview in TCS. Please send soon.

    email id : rinmoni@gmail.com

    ReplyDelete
  12. Please send the answers @ kaurtanveer28@gmail.com
    It would be very helpful.
    Thanks in advance!

    ReplyDelete
  13. PLEASE SEND THE ANSWERE praveenmynampati30@gmail.com

    ReplyDelete
  14. please send me answer at hitendrapareek@gmail.com

    ReplyDelete
  15. Hi Suresh ,
    please send me the ans at mohit90jathi@gmail.com

    ReplyDelete
  16. Hi suresh,
    can you please mail me the answers,my id is prince.tabrez7@gmail.com,thankyou.

    ReplyDelete