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?

31 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
  17. Hi,
    Send me the answers to krishna.sree23@gmail.com

    ReplyDelete
  18. Hi Suresh send the answers at tatushar3@gmail.com

    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
  20. pls send me answer mail id is: shivanand.patil12@gmail.com

    ReplyDelete
  21. pls send me the answers are very helpful mail id;yharish888@gmail.com

    ReplyDelete
  22. Please send me answer pls pls....m3.infa@gmail.com

    ReplyDelete
  23. I have raed your blog that's very nice please follow us on :-The data warehouse interview questions are providing to be quite helpful and here with the help of expert written pages and links you can learn more facts about it at ease. The informatica interview questions and answers for experienced has earned the value and many students or individual looking for his profession is seen following this particular book or questionnaire for reference purpose.

    ReplyDelete
  24. Hi,
    Thank you for sharing these useful questions. Please do share the answers to the same. My email id: anjali.nandagopal@gmail.com

    ReplyDelete
  25. Hi can you please share the answers also. I have interview scheduled tomorrow

    ReplyDelete
  26. Hi Buddy,

    This is one awesome blog.
    Much thanks again
    . Fantastic.

    I would like to import an xml schema target into Informatica BDE developer and
    load this xml file without using a Data Parser

    I would like to utilize this feature as we do it in Informatica Powercenter
    Is this possible ?

    Appreciate your effort for making such useful blogs and helping the community.
    Thank you,
    Mahesh

    ReplyDelete
  27. Hi There,


    You make learning and reading addictive. All eyes fixed on you. Thank you being such a good and trust worthy guide.

    We are working on integration of SFDC (SalesForce CRM) with Exact Target(ET) (SalesForce Marketing Clound) through Informatica PowerCenter 9.5.1.
    But facing below issues:
    1) While importing SalesForce object into PowerCenter : Getting an error "timed out"
    2) How to connect to Exact target from power Center using API (we tested this from Java by passing proxy to webservie but not sure how to pass proxy to webservice in power Center)

    Awesome! Thanks for putting this all in one place. Very useful!


    Many Thanks,
    Renina

    ReplyDelete