1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

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 are the uses of a Sequence Generator transformation?




We can perform the following tasks with a Sequence Generator transformation:
o    Create keys
o    Replace missing values
o    Cycle through a sequential range of numbers

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy