|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 is the difference between a Database and a Datawarehouse?

SCJP 1.5/1.6 Exam Kit

!!!Answer!!!- From Technical Expert


Database is a place where data is taken as base to data access to retrieve and load data, whereas, a data warehouse is a place where application data is managed for analysis and reporting services. Database stores data in the form of tables and columns. On the contrary, in a data warehouse, data is subject oriented and stored in the form of dimensions and packages which are used for analysis purpose. In short, we must understand that a database is used for running an enterprise but a data warehouse helps in how to run an enterprise.

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

Answered By : dd Replied Date : Jun 23 2008
Answer : good one
Answered By : null Replied Date : Jan 9 2012
Answer :

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

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

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

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

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

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

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

Answered By : null Replied Date : May 30 2011
Answer :

Answered By : null Replied Date : May 27 2011
Answer :

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Answered By : null Replied Date : Sep 30 2010
Answer :

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

Answered By : null Replied Date : Jun 27 2012
Answer :

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

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

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

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

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

Answered By : null Replied Date : Feb 19 2013
Answer :

Answered By : null Replied Date : Mar 25 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.