TechFAQ

Informatica interview questions

• Which transformation should we use to normalize the COBOL and relational sources? view answer
• Difference between static cache and dynamic cache? view answer
• What are the join types in joiner transformation? view answer
• In which condtions we can not use joiner transformation(Limitaions of joiner transformation)? view answer
• What is the look up transformation? view answer
• What are the diffrence between joiner transformation and source qualifier transformation? view answer
• Why use the lookup transformation? view answer
• How can you improve session performance in aggregator transformation? view answer
• Can you use the maping parameters or variables created in one maping into any other reusable transformation? view answer
• What is meant by lookup caches? view answer
• What is source qualifier transformation? view answer
• How the informatica server increases the session performance through partitioning the source? view answer
• What are the settiings that you use to cofigure the joiner transformation? view answer
• What are the rank caches? view answer
• What is Code Page Compatibility? view answer
• How can you create or import flat file definition in to the warehouse designer? view answer
• What is aggregate cache in aggregator transforamtion? view answer
• How can you recognise whether or not the newly added rows in the source are gets insert in the target? view answer
• What are the types of lookup? view answer
• What are the types of metadata that stores in repository? view answer
• What happens if Informatica server doesn't find the session parameter in the parameter file? view answer
• Can you access a repository created in previous version of informatica? view answer
• Without using ETL tool can u prepare a Data Warehouse and maintain? view answer
• How do you identify the changed records in operational data? view answer
• Why couldn't u go for Snowflake schema? view answer
• Name some measures in your fact table? view answer
• How many dimension tables did you had in your project and name some dimensions (columns)? view answer
• How many Fact and Dimension tables are there in your project? view answer
• How many Data marts are there in your project? view answer
• What is the daily data volume (in GB/records)? What is the size of the data extracted in the extraction process? view answer
• What is the size of the database in your project? view answer
• What is meant by clustering? view answer
• Whether are not the session can be considered to have a heterogeneous target is determined? view answer
• Under what circumstance can a target definition are edited from the mapping designer. Within the mapping where that target definition is being used? view answer
• Can a source qualifier be used to perform a outer join when joining 2 database? view answer
• If u r source is flat file with delimited operator.when next time u want change that delimited operator where u can make? view answer
• If index cache file capacity is 2MB and datacache is 1 MB. If you enter the data of capacity for index is 3 MB and data is 2 MB. What will happen? view answer
• Difference between next value and current value ports in sequence generator? view answer
• How does dynamic cache handle the duplicates rows? view answer
• How will u find whether your mapping is correct or not without connecting session? view answer
• If you are using aggregator transformation in your mapping at that time your source contain dimension or fact? view answer
• My input is oracle and my target is flat file shall I load it? How? view answer
• for a session, can I use 3 mappings? view answer
• Type of loading procedures? view answer
• Are you involved in high level r low level design? What is meant by that high level design n low level design? view answer
• what r the dimension load methods? view answer
• where we are using lkp b/n source to stage or stage to target? view answer
• How will you do SQL tuning? view answer
• did u use any other tools for scheduling purpose other than workflow manager or pmcmd? view answer
• What is SQL mass updating? view answer
• what is unbounded exception in source qualifier? view answer
• Using unconnected lookup how we you remove nulls n duplicates? view answer
• I have 20 lookup, 10 joiners, 1 normalizer how will you improve the session performance? view answer
• What is version controlling? view answer
• How is the Sequence Generator transformation different from other transformations? view answer
• What are the advantages of Sequence generator? Is it necessary, if so why? view answer
• What are the uses of a Sequence Generator transformation? view answer
• What is Sequence Generator Transformation? view answer
• What is the difference between connected lookup and unconnected lookup? view answer
• What are connected and unconnected Lookup transformations? view answer
• What is a Lookup transformation and what are its uses? view answer
• What is a lookup table? view answer
• Where do you define update strategy? view answer
• What is Update Strategy? view answer
• What are the different types of Transformations? view answer
• What is a transformation? view answer
• What are the tools provided by Designer? view answer
• What are the different types of Commit intervals? view answer
• What is Event-Based Scheduling? view answer
• I have the Administer Repository Privilege, but I cannot access a repository using the Repository Manager. view answer
• My privileges indicate I should be able to edit objects in the repository, but I cannot edit any metadata. view answer
• How does read permission affect the use of the command line program, pmcmd? view answer
• I do not want a user group to create or edit sessions and batches, but I need them to access the Server Manager to stop the Informatica Server. view answer
• I created a new group and removed the Browse Repository privilege from the group. Why does every user in the group still have that privilege? view answer
• After creating users and user groups, and granting different sets of privileges, I find that none of the repository users can perform certain tasks, even the Administrator. view answer
• What are the different types of locks? view answer
• What is Local Repository? view answer
• What is a Global repository? view answer
• When should you create the dynamic data store? Do you need a DDS at all? view answer
• What is Dynamic Data Store? view answer
• What are Target definitions? view answer
• What are Source definitions? view answer
• What are Shortcuts? view answer
• What are Sessions and Batches? view answer
• What are Reusable transformations? view answer
• What are Transformations? view answer
• What are mapplets? view answer
• What are mappings? view answer
• What are folders? view answer
• What is a metadata? view answer
• What are different kinds of repository objects? And what it will contain? view answer
• What are different kinds of repository objects? And what it will contain? view answer
• What is a repository? view answer
• What are the new features and enhancements in PowerCenter 5.1? view answer
• What is the difference between PowerCenter and PowerMart? view answer
• Why do we need SQL overrides in Lookup transformations? view answer
• What is session? view answer
• What is workflow? view answer
• What is worklet? view answer
• Which ETL tool is more preferable Informatica or Data Stage and why? view answer
• What is a mapplet? view answer
• What is the use of auxiliary mapping? view answer
• What is authenticator? view answer
• How do we create primary key only on odd numbers? view answer
• What is the difference between source qualifier transformation and application source qualifier transformation? view answer
• What are the types of loading in Informatica? view answer
• What is the use of control break statements? view answer
• What is the difference between active transformation and passive transformation? view answer
• What are the various types of transformation? view answer
• What is the use of tracing levels in transformation? view answer
• What is the difference between a Database and a Datawarehouse? view answer
• What are the different types of OLAP TECHNOLOGY? view answer
• What is Data Modeling? What are the different types of Data Modeling? view answer
• What is the need of building a data warehouse? view answer
• What is drill-down and drill-up? view answer
• What is cube? view answer
• 1. What is a Data warehouse? view answer

!!! Informatica interview questions !!!

What is worklet?

Suggested Jobs