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?

34 comments:

  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.

      Ciao,
      Hima

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

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

    ReplyDelete
  4. 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
  5. Hi suresh, Plz send the answerrs..

    nishu.dwh@gmail.com

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

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

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

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

    Regards
    Rakesh

    ReplyDelete
  10. 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
  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 : 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
  12. 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
  13. Please send the answers @ kaurtanveer28@gmail.com
    It would be very helpful.
    Thanks in advance!

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

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

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

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

    ReplyDelete
  18. Hi,
    Send me the answers to krishna.sree23@gmail.com

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

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

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

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

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

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

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

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

    ReplyDelete
  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,
    Mahesh

    ReplyDelete
  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,
    Renina

    ReplyDelete
  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,
    Preethi.

    ReplyDelete
  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

    ReplyDelete