Monday, June 6, 2011

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

1.explain  ur project? 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?

  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? using which transformation u can capture the rejected records and where it will be stored?

12.what is the shortcut and reusable transformation? 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?


  1. Replies
    1. Hi Suresh,

      Thank You so much for this blog. It helped me lot. I am a Technical Recruiter by profession and first time working on this technology was bit tough for me, this article really helped me a lot to understand the details to get started with.

      If you are trying to implement SCD type 1 load try doing the same without using Router in the mapping.
      HM profiles are assigned to users through MRM roles. Normally a user is only assigned a single role. In cases where more than one role are assigned, the user is prompted at the appropriate time to select the profile to work with.
      Also use single target instance instead of two if you are using two instances in the current mapping.

      Kindly try this approach and let me know if it works or not.

      Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.


  2. pls send me answer it really helpful for me
    pl send on

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

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

  5. Hi suresh, Plz send the answerrs..

  6. Hi Suresh,will please share the answers on my mail

  7. Please share the answer to my id

  8. Hi Suresh, Thanks a lot for the efforts.
    Please send the answers on

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


  10. Hi Suresh,
    Thanks for sharing these questions.Could you please send me the answer also on

    Thanks in advance.
    Hari Lal

  11. 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 :

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

  12. Hi Suresh,

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

    email id :

  13. Please send the answers @
    It would be very helpful.
    Thanks in advance!


  15. please send me answer at

  16. Hi Suresh ,
    please send me the ans at

  17. Hi suresh,
    can you please mail me the answers,my id is,thankyou.

  18. Hi,
    Send me the answers to

  19. Hi Suresh send the answers at

  20. This comment has been removed by the author.

  21. pls send me answer mail id is:

  22. pls send me the answers are very helpful mail id;

  23. Please send me answer pls

  24. 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.

  25. Hi,
    Thank you for sharing these useful questions. Please do share the answers to the same. My email id:

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

  27. 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,

  28. 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,

  29. Hello There,

    Thank you for update. From now onward I start to use this blog in my training practice. Thank you for explaining each step in screen shots. Informatica MDM Training USA I use blogs for my easy reference which were quite useful to get started with. I found new issues as example below .. From the source i see that in lookup table both records are overlapping so i need to return both of the records from the lookup
    How can this be achieved ? Is there any way i can mention in the where clause of the Lookup Overide query
    But great job man, do keep posted with the new updates.

    Best Regards,

  30. Hi,

    Thank u For sharing this unique article. Definitely a life saver.
    We cant add filter while creating/inserting a record in database where as we can add filter while modifying(search/update/delete) record. As Business entity supports CRUD operations it violates rule. Informatica MDM Training

    Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.
    Kind Regards,
    Irene Hynes