{"id":26,"date":"2006-11-21T17:50:07","date_gmt":"2006-11-21T17:50:07","guid":{"rendered":"http:\/\/etlguru.com\/blog\/2006\/11\/21\/informatica-interview-questions-faqs\/"},"modified":"2011-05-26T22:38:39","modified_gmt":"2011-05-26T22:38:39","slug":"informatica-interview-questions-faqs","status":"publish","type":"post","link":"https:\/\/etlguru.com\/?p=26","title":{"rendered":"Informatica interview questions & FAQs"},"content":{"rendered":"
What is a source qualifier?
\nWhat is a surrogate key?
\nWhat is difference between Mapplet and reusable transformation?
\nWhat is DTM session?
\nWhat is a Mapplet?
\nWhat is a look up function? What is default transformation for the look up function?
\nWhat is difference between a connected look up and unconnected look up?
\nWhat is up date strategy and what are the options for update strategy?
\nWhat is subject area?
\nWhat is the difference between truncate and delete statements?
\nWhat kind of Update strategies are normally used (Type 1, 2 & 3) & what are the differences?
\nWhat is the exact syntax of an update strategy?
\nWhat are bitmap indexes and how and why are they used?
\nWhat is bulk bind? How does it improve performance?
\nWhat are the different ways to filter rows using Informatica transformations?
\nWhat is referential Integrity error? How do you rectify it?
\nWhat is DTM process?
\nWhat is target load order?
\nWhat exactly is a shortcut and how do you use it?
\nWhat is a shared folder?
\nWhat are the different transformations where you can use a SQL override?
\nWhat is the difference between a Bulk and Normal mode and where exactly is it defined?
\nWhat is the difference between Local & Global repository?
\nWhat are data driven sessions?
\nWhat are the common errors while running a Informatica session?
\nWhat are worklets and what is their use?
\nWhat is change data capture?
\nWhat exactly is tracing level?
\nWhat is the difference between constraints based load ordering and target load plan?
\nWhat is a deployment group and what is its use?
\nWhen and how a partition is defined using Informatica?
\nHow do you improve performance in an Update strategy?
\nHow do you validate all the mappings in the repository at once?
\nHow can you join two or more tables without using the source qualifier override SQL or a Joiner transformation?
\nHow can you define a transformation? What are different types of transformations in Informatica?
\nHow many repositories can be created in Informatica?
\nHow many minimum groups can be defined in a Router transformation?
\nHow do you define partitions in Informatica?
\nHow can you improve performance in an Aggregator transformation?
\nHow does the Informatica know that the input is sorted?
\nHow many worklets can be defined within a workflow?
\nHow do you define a parameter file? Give an example of its use.
\nIf you join two or more tables and then pull out about two columns from each table into the source qualifier and then just pull out one column from the source qualifier into an Expression transformation and then do a \u00e2\u20ac\u02dcgenerate SQL\u00e2\u20ac\u2122 in the source qualifier how many columns will show up in the generated SQL.
\nIn a Type 1 mapping with one source and one target table what is the minimum number of update strategy transformations to be used?
\nAt what levels can you define parameter files and what is the order?
\nIn a session log file where can you find the reader and the writer details?
\nFor joining three heterogeneous tables how many joiner transformations are required?
\nCan you look up a flat file using Informatica?
\nWhile running a session what default files are created?
\nDescribe the use of Materialized views and how are they different from a normal view.<\/p>\n

Contributed by Mukherjee, Saibal (ETL Consultant)<\/em><\/p>\n

Many readers are asking \u00e2\u20ac\u0153Where\u00e2\u20ac\u2122s the answer?\u00e2\u20ac\u009d Well it will take some time before I get time to write it\u00e2\u20ac\u00a6 But there is no reason to get upset\u00e2\u20ac\u00a6 The informatica help files should have all of these answers! \":-)\"<\/em><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

What is a source qualifier? What is a surrogate key? What is difference between Mapplet and reusable transformation? What is DTM session? What is a Mapplet? What is a look up function? What is default transformation for the look up function? What is difference between a connected look up and unconnected look up? What is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,8,32,31,1],"tags":[],"class_list":["post-26","post","type-post","status-publish","format-standard","hentry","category-etl-tools","category-informatica","category-informatica-faqs","category-interview-faqs","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/26","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=26"}],"version-history":[{"count":8,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/26\/revisions"}],"predecessor-version":[{"id":206,"href":"https:\/\/etlguru.com\/index.php?rest_route=\/wp\/v2\/posts\/26\/revisions\/206"}],"wp:attachment":[{"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/etlguru.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}