|Home |Login |Registration |Struts Step by Step Tutorial |Hibernate Step by Step Tutorial |Spring Step by Step Tutorial |JSP Step by Step Tutorial |JDBC Step by Step Tutorial |Web Services Step by Step Tutorial |EJB fundamentals | ORACLE Step by Step Tutorial | SCJP 5.0 and SCJP 6.0 Study Guide | SCWCD 5.0 Study Guide | SCJP Tips
Java mock test | SCJP mock test | SCJP DUMP | SCBCD mock test |Java online test exam | JSP online test | ORACLE online test | Hibernate online test | Servlet online test | Struts online test | EJB online test | C online test | C++ online test | Aptitude online test

Java interview questions | JSP interview questions | ORACLE interview questions | Hibernate interview questions | Servlet interview questions | Struts interview questions | JDBC interview questions | C/C++ interview questions | Spring interview questions | JMS interview questions | Informatica interview questions | EJB interview questions | OOPS and Design Pattern interview questions
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) JobsJobs and Walkins

 

Recent 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 Frequently Asked Questions !!!

What are the new features and enhancements in PowerCenter 5.1?

SCJP 1.5/1.6 Exam Kit

!!!Answer!!!- From Technical Expert

The major features and enhancements to PowerCenter 5.1 are:
a) Performance Enhancements
?    High precision decimal arithmetic. The Informatica Server optimizes data throughput to increase performance of sessions using the Enable Decimal Arithmetic option.
?    To_Decimal and Aggregate functions. The Informatica Server uses improved algorithms to increase performance of To_Decimal and all aggregate functions such as percentile, median, and average.
?    Cache management. The Informatica Server uses better cache management to increase performance of Aggregator, Joiner, Lookup, and Rank transformations.
?    Partition sessions with sorted aggregation. You can partition sessions with Aggregator transformation that use sorted input. This improves memory usage and increases performance of sessions that have sorted data.
b) Relaxed Data Code Page Validation
When enabled, the Informatica Client and Informatica Server lift code page selection and validation restrictions. You can select any supported code page for source, target, lookup, and stored procedure data.
c) Designer Features and Enhancements
?    Debug mapplets. You can debug a mapplet within a mapping in the Mapping Designer. You can set breakpoints in transformations in the mapplet.
?    Support for slash character (/) in table and field names. You can use the Designer to import source and target definitions with table and field names containing the slash character (/). This allows you to import SAP BW source definitions by connecting directly to the underlying database tables.
d) Server Manager Features and Enhancements
?    Continuous sessions. You can schedule a session to run continuously. A continuous session starts automatically when the Load Manager starts. When the session stops, it restarts immediately without rescheduling. Use continuous sessions when reading real time sources, such as IBM MQSeries.
?    Partition sessions with sorted aggregators. You can partition sessions with sorted aggregators in a mapping.
?    Register multiple servers against a local repository. You can register multiple PowerCenter Servers against a local repository.

Answered By : null Replied Date : Mar 3 2012
Answer :

Answered By : null Replied Date : Jan 9 2012
Answer :

Answered By : null Replied Date : Jan 7 2012
Answer :

Answered By : null Replied Date : Oct 19 2011
Answer :

Answered By : null Replied Date : Oct 13 2011
Answer :

Answered By : null Replied Date : Oct 5 2011
Answer :

Answered By : null Replied Date : Oct 4 2011
Answer :

Answered By : null Replied Date : Oct 4 2011
Answer :

Answered By : null Replied Date : Sep 29 2011
Answer :

Answered By : null Replied Date : Sep 23 2011
Answer :

Answered By : null Replied Date : Sep 15 2011
Answer :

Answered By : null Replied Date : Sep 15 2011
Answer :

Answered By : null Replied Date : Jul 6 2011
Answer :

Answered By : null Replied Date : Jun 19 2011
Answer :

Answered By : null Replied Date : Jun 18 2011
Answer :

Answered By : null Replied Date : Jun 1 2011
Answer :

Answered By : null Replied Date : Apr 13 2011
Answer :

Answered By : null Replied Date : Apr 4 2011
Answer :

Answered By : null Replied Date : Apr 1 2011
Answer :

Answered By : null Replied Date : Jan 26 2011
Answer :

Answered By : null Replied Date : Jan 25 2011
Answer :

Answered By : null Replied Date : Jan 20 2011
Answer :

Answered By : null Replied Date : Jan 6 2011
Answer :

Answered By : null Replied Date : Jan 4 2011
Answer :

Answered By : null Replied Date : Dec 12 2010
Answer :

Answered By : null Replied Date : Nov 21 2010
Answer :

Answered By : null Replied Date : Nov 6 2010
Answer :

Answered By : null Replied Date : Oct 9 2010
Answer :

Answered By : null Replied Date : Aug 12 2010
Answer :

Answered By : null Replied Date : May 8 2012
Answer :

Answered By : null Replied Date : Aug 4 2012
Answer :

Answered By : null Replied Date : Aug 8 2012
Answer :

Answered By : null Replied Date : Sep 9 2012
Answer :

Answered By : null Replied Date : Oct 20 2012
Answer :

Answered By : null Replied Date : Nov 14 2012
Answer :

Answered By : null Replied Date : Dec 2 2012
Answer :

Answered By : null Replied Date : Dec 16 2012
Answer :

Answered By : null Replied Date : Jan 20 2013
Answer :

Answered By : null Replied Date : Mar 25 2013
Answer :

Answered By : null Replied Date : Apr 15 2013
Answer :

 

You can also contribute to this answer:

Your Name:
Answer:

 
Ask Question and get answer from Expert.
View Answers List from Expert.

The information you are posting should be related to java and ORACLE technology. Not political.