resourceone.info Religion Informatica Interview Questions Ebook

INFORMATICA INTERVIEW QUESTIONS EBOOK

Sunday, June 16, 2019


Buy INFORMATICA INTERVIEW QUESTIONS & ANSWERS: Hands on tips & questions to crack the interview.: Read 1 Books Reviews - resourceone.info INFORMATICA INTERVIEW QUESTIONS & ANSWERS: Hands on tips & questions to crack the interview. eBook: ks: resourceone.info: Kindle Store. Here I have collected some qood interview questions with answers about Informatica that is generally asked. Download Complete Questions in PDF. It will be.


Informatica Interview Questions Ebook

Author:CHANTAL GLEASON
Language:English, Spanish, Hindi
Country:Iraq
Genre:Health & Fitness
Pages:616
Published (Last):02.04.2016
ISBN:233-2-70230-870-6
ePub File Size:30.45 MB
PDF File Size:13.67 MB
Distribution:Free* [*Regsitration Required]
Downloads:28598
Uploaded by: MONROE

Where can I find scenario-based interview questions for Informatica .info// 12/resourceone.info Contains Important Informatica Interview Questions with Answers and Informatica and Answers PDF | Informatica eBooks | Informatica | What is Informatica?. These questions are frequently asked in all IT Companies like 3i infotech,Cts,Tcs This part contains only Informatica Interview Questions and answers for both with Answers PDF Free Download | Informatica Developer Interview Questions.

Q 12 What is Enterprise Data Warehousing? When a large amount of data is assembled at a single access point then it is called as Enterprise Data Warehousing. This data can be reused and analyzed at regular intervals or as per the need of the time requirement. Considered as the central database or say a single point of access, Enterprise data warehousing provides a complete global view and thus helps in decision support.

Q 13 What is the benefit of Session Partitioning? While Integration Service is running in the environment the workflow is partitioned for better performance. These partitions are then used to perform Extraction, Transformation, and Loading. Command Tasks are used to create Index. Command Task scripts can be used in a session of workflow to create an index. Session is a Set of Instructions that are used while moving data from the source to destination. We can partition the session to implement several sequences of sessions to improve the server performance.

After creating session we can use server manager or command line program pmcmd to stop or start the session. Batches are the collection of sessions which is used to migrate the data from the source to target on a server. Batches can have the largest number of sessions in it but they cause more network traffic whereas less number of sessions in a batch can be moved rapidly.

Mapping is a collection of source and targets which are linked with each other through certain sets of transformations such as Expression Transformation, Sorter Transformation, Aggregator Transformation, Router Transformation etc. Transformation can be defined as a set of rules and instruction that are to be applied to define data flow and data load at the destination.

It is a mapping transformation which is used to transform data in one record at a time. Expression Transformation can be passive or connected.

The expression is used for data manipulation and output generation using conditional statements. Q 20 What is Update Strategy Transformation?

Buy for others

We can set a conditional Logic within the Update Strategy Transformation to tag it. Sorter Transformation is used to sort large volume of data through multiple ports. Sorter Transformation can be Active, Passive or Connected. Active Transformation passes through Mapping and changes a number of rows whereas Passive Transformation passes through Mapping but does not change the number of rows.

Router Transformation is used to filter the source data. It is much like Filter Transformation but the only difference is that Filter Transformation uses only one transformation condition and returns the rows that do not fulfill the condition, Whereas Router Transformation uses multiple transformation conditions and returns the rows that match even a single condition.

Q 23 What is Rank Transformation? Rank Transformation is Active as well as Connected. It is used to sort and rank a set of records either top or bottom. Rank Transformation is also used to select data with a largest or smallest numeric value based on a specific port. Rank Index is assigned by the task designer to each record. The rank index port is used to store ranking position for each row.

Rank Transformation identifies each row from the top to bottom and then assigns Rank Index. Code provides Error Handling Mechanism during each session. Junk Dimension is a structure that consists a group of some junk attributes such as random codes or flags. Mapplet is created in Mapplet Designer in the Designer Tool. It is basically the function that is used by an expression transformation in order to search a specific value in a record. There can be unlimited searches within the Decode function where a port is specified for returning result values.

This function is usually used in cases where it is required to replace nested IF statements or to replace lookup values by searching in small tables with constant values.

Decode is a function that is used within Expression Transformation. Aggregator Transformation can be active or connected. It performs an aggregate calculation on data using aggregate type function viz. Sequence Generator Transformation can be Passive or Connected. Union Transformation is used to combine the data from different sources and frame it with the same port and data type.

It is much like a Clause in SQL. Source Qualifier Transformation is useful in Mapping, whenever we add relational flat files it is automatically created.

It is an active and connected transformation that represents those rows which are read by integration service. Worklet saves the logic and tasks at a single place to reuse. Home page Contact Us. Net DWH New.

Top 64 Informatica Interview Questions with Answers

Informatica Interview Question and Answers. What are Source Qualifier transformation? Source Qualifier transformation is an Active and Connected transformation. When adding a relational or a flat file source definition to a mapping, it is must to connect it to a Source Qualifier transformation.

The Source Qualifier performs the various tasks such as overriding default SQL query, filtering records; join data from two or more tables etc. It is much like Filter Transformation but the only difference is that Filter Transformation uses only one transformation condition and returns the rows that do not fulfill the condition, Whereas Router Transformation uses multiple transformation conditions and returns the rows that match even a single condition.

Q 23 What is Rank Transformation? Ans: Rank Transformation is Active as well as Connected.

It is used to sort and rank a set of records either top or bottom. Rank Transformation is also used to select data with a largest or smallest numeric value based on a specific port. Ans: Rank Index is assigned by the task designer to each record.

The rank index port is used to store ranking position for each row.

Buying Options

Rank Transformation identifies each row from the top to bottom and then assigns Rank Index. Ans: Code provides Error Handling Mechanism during each session. Q 26 What are Junk Dimensions?

Ans: Junk Dimension is a structure that consists a group of some junk attributes such as random codes or flags. Mapplet is created in Mapplet Designer in the Designer Tool. It is basically the function that is used by an expression transformation in order to search a specific value in a record.

There can be unlimited searches within the Decode function where a port is specified for returning result values. This function is usually used in cases where it is required to replace nested IF statements or to replace lookup values by searching in small tables with constant values.

Decode is a function that is used within Expression Transformation.

You might also like: MOLECULAR BIOLOGY LODISH EBOOK

Ans: Aggregator Transformation can be active or connected. It performs an aggregate calculation on data using aggregate type function viz. Ans: Union Transformation is used to combine the data from different sources and frame it with the same port and data type.

It is much like a Clause in SQL. Ans: Source Qualifier Transformation is useful in Mapping, whenever we add relational flat files it is automatically created. It is an active and connected transformation that represents those rows which are read by integration service.

Worklet saves the logic and tasks at a single place to reuse. Worklet is much similar to the Mapplet and is defined as the group of tasks that can be either reusable or non-reusable at the workflow level. It can be added to as much number of workflows as required. With its reusability feature, much time is saved as reusable logic can be developed once and can be placed from where it can be reused. Mapplets are created in Mapplet designer and are a part of the Designer tool.

It basically contains a set of transformations that are designed to be reused in multiple mapping. Mapplets are said to be reusable objects which simplify mapping by: Including multiple transformations and source definitions. Not required to connect to all input and output ports.If there are multifold source qualifiers linked to different targets then one can entitle order in which informatica server loads data into targets. Transaction control: If you want to create transactions and have absolute control over rollbacks and commits, count on this component to bail you out.

Mapplet is created in Mapplet Designer in the Designer Tool. Q 59 What is Dynamic Cache? Ans: It is a diverse input group transformation which can be used to combine data from different sources.