Thursday 18 September 2014

Informatica Online Training By SVR Technologies

Leave a Comment
Informatica is one of the reputed online courses at present it has got the potentiality in the market. Every IT individuals and business organizations are looking forward to make things easier. Informatica is widely used ETL tool to extract source data and applying to the desired objective after completion of the requisite transformation. Initiating career with Informatica will be a boon for growth of good well established career. Huge demand and widened scope for Informatica professionals all around the world mostly in countries like US, UK, South Africa, Singapore, and in India. Most of the IT people are looking forward to upgrade their skills to find better career growth & income. For the people who wants to look after existing job and also to update with the other demandable software’s, Online training is one of the best choice and an ideal solution.



Informatica is software which allows user to create data ware house in a simple way. “Data Warehousing” is been introduced by Informatica. According to Informatica, its Intelligent Data Platform aims to integrate data ranging from sensors to transactional and to enterprise, automatically detects relationships and classifies information and recommends data set’s for business users. The other perception behind Data Information Platform is data & analytics which is self service. Informatica Corporation enjoys generosity in the established technical market. The skilled knowledge on the software makes business to enjoy a numerous benefits. 

The software, in itself, is amongst the best result oriented software and offers a great amount of information and help people belonging to a choice of fields. Informatica increases the productivity of the business and offers a great amount of results show casing the achievement of the desired goals by the organization often. With such extreme benefits, every one desires to use software for business. In order to achieve the finest result from it, the knowledge of the software is very vital. So the knowledge on Informatica software through Informatica online training is very much required. Similarly, the Informatica software offers a generous number of benefits to both the users and learners alike.



 For instance, the software online program reduces the performance costs and helps to understand the Informatica software better and in a conventional manner. The risks and the qualms involved with the Informatica are reduced to a great extent with the knowledge of the software. A detailed knowledge and understanding of the Informatica software is what the Informatica online training offers to the learners. This way, the benefits and the uses of online training program can be enjoyed to the maximum.

Contact us:

Email: info@svrtechnologies.com
Skype id: svrtechnologies
Contact: 91-9885022027 (INDIA)   || 001-2103904819 (USA)
              91-8886988814
Read More...

Friday 27 September 2013

Top 10 Frequently Asked Interview Questions Answers About Informatica

Leave a Comment
This article "Top 10 Frequently Asked Interview Questions Answers About Informatica" helps the customers those who are searching for mostly asked questions about Informatica.





1. What are the differences between Connected and Unconnected Lookup?

Ans:  Connected lookup: Connected lookup take part in dataflow and receives input directly from the pipeline.  It can use both dynamic and static cache.  Connected lookup can return more than one column value (output port ). Connected lookup caches all lookup columns.  Supports user-defined default values.
Unconnected lookup:  It  receives input values from the result of a LKP: expression in another transformation.  Unconnected Lookup cache can NOT be dynamic.  It can return only one column value i.e. output port.  Does not support user defined default values.


2. What are the characteristics of  Complex Mapping?

Ans:  Characteristics:
  • Complicated requirement
  • More no. of transformations
  • Having complex business logic
  • May require combination of two or more methods
  • Complex business logic
  • More than 30 unconnected lookup


3. What is Data warehouse?

Ans: "A Data warehouse is a subject oriented, included, time variant, non random collection of data in support of management's decision making process".


4. Define look up function?


Ans: The lookup function is used to compare source data with another table based on a convinced condition. If the condition is true, than the lookup function returns columns that satisfy condition.


5.  What is the difference between stop and abort options in workflow monitor?

Ans: Stop waits for all running objects to complete and then finish the process however abort stops the entire object running immediately.


6.  Write the types of data warehouses?               

Ans: There are three types of data warehouses
  • Enterprise Data Warehouse
  • ODS (operational data store)
  • Data Mart



7.  What is Data mart?


Ans:  A data mart is a subset of data warehouse that is intended for a particular line of business, such as sales, marketing, or finance. In a dependent data mart, data can be resulting from an enterprise wide data warehouse. 


8.  Define Data Transformation Manager (DTM)?

Ans: After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run.


9.  Write about types of dimensions available in informatica?

Ans: There are three types of dimensions.
  • Star schema
  • Snowflake schema
  • Galaxy Schema


10.  Explain about snow flake schema?

Ans: A Snowflake schema is nothing but one Fact table which is associated to a number of dimension tables, the snowflake and star schema are the process of storing data which are multidimensional in nature.





Read More...