Basic Informatica Interview Question Answers

57 %
43 %
Information about Basic Informatica Interview Question Answers
Education

Published on February 20, 2014

Author: swetasingh714

Source: slideshare.net

Description

Informatica Interview Question Answers asked in Companies

What is the difference between STOP and ABORT options in Workflow Monitor? When we issue the STOP command on the executing session task, the Integration Service stops reading data from source. It continues processing, writing and committing the data to targets. If the Integration Service cannot finish processing and committing data, we can issue the abort command. In contrast ABORT command has a timeout period of 60 seconds. If the Integration Service cannot finish processing and committing data within the timeout period, it kills the DTM process and terminates the session. How to Delete duplicate row using Informatica Scenario 1: Duplicate rows are present in relational database Suppose we have Duplicate records in Source System and we want to load only the unique records in the Target System eliminating the duplicate rows. What will be the approach? Assuming that the source system is a Relational Database, to eliminate duplicate records, we can check the Distinctoption of the Source Qualifier of the source table and load the target accordingly.

Which transformation should u need while using the COBOL sources as source definitions?informatica Normalizer transformation is used to normalize the data. Since COBOL sources r often consists of Demoralized data . Which transformation should we use to normalize the COBOL and relational sources? Normalizer Transformation. When you drag the COBOL source in to the mapping Designer workspace, the normalizer transformation automatically appears, creating input and output ports for every column in the source. How the informatica server sorts the string values in Rank transformation? When the informatica server runs in the ASCII data movement mode it sorts session data using Binary sort order. If U configure the session to use a binary sort order, the informatica server calculates the binary value of each string and returns the specified number of rows with the highest binary values for the string. What r the rank caches? informatica powercenter During the session, the informatica server compares an input row with rows in the data cache. If the input row out-ranks a stored row, the informatica server replaces the stored row with the input row. The informatica server stores group information in an index cache and row data in a data cache. What is the Rank index in Rank transformation? informatica powercenter In Informatica The Designer automatically creates a RANKINDEX port for each Rank transformation. The Informatica Server uses the Rank Index port to store the ranking position for each record in a group. For example, if you create a Rank transformation that ranks the top 5 salespersons for each quarter, the rank index numbers the salespeople from 1 to 5: What is the Router transformation? informatica powercenter A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. However, a Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. A Router transformation tests data for one or more conditions and gives you the option to route rows of data that do not meet any of the conditions to a default output group. If you need to test the same input data based on multiple conditions, use a Router

Transformation in a mapping instead of creating multiple Filter transformations to perform the same task. What are the types of groups in Router transformation? informatica powercenter Input group Output group The designer copies property information from the input ports of the input group to create a set of output ports for each output group. Two types of output groups User defined groups Default group U can not modify or delete default groups. Why we use stored procedure transformation? informatica powercenter For populating and maintaining data bases. What are the types of data that passes between informatica server and stored procedure? In Informatica there are 3 types of data Input/Out put parameters Return Values Status code What is the status code? informatica powercenter In Informatica Status code provides error handling for the informatica server during the session. The stored procedure issues a status code that notifies whether or not stored procedure completed successfully. This value can not seen by the user. It only used by the informatica server to determine whether to continue running the session or stop. What is source qualifier transformation? informatica powercenter In Informatica When we add a relational or a flat file source definition to a mapping, we need to connect it to a source qualifier transformation. The source qualifier transformation represents the records that the informatica server reads when it runs a session. What are the tasks that Informatica source qualifier perform? informatica powercenter Join data originating from same source data base. Filter records when the informatica server reads source data. Specify an outer join rather than the default inner join

Specify sorted records. Select only distinct values from the source. Creating a custom query to issue a special SELECT statement for the informatica server to read source data What is Data driven? informatica powercenter The informatica server follows instructions coded into update strategy transformations within the session mapping determine how to flag records for insert, update, delete or reject. If u do not choose data driven option setting, the informatica server ignores all update strategy transformations in the mapping. Informatica Interview Question Answers Collection

Add a comment

Comments

http://soonerbowl.com/Birthdays. | 27/12/14
wholesale nfl jerseys online from china free shipping [url=http://soonerbowl.com/Birthdays.html]http://soonerbowl.com/Birthdays.html[/url]

Related presentations

Related pages

Informatica Interview Questions | GeekInterview.com

... 1156 Informatica interview questions and 3165 answers by expert members with experience in Informatica subject. Discuss each question ... answers above ...
Read more

Best Informatica Interview Questions & Answers - Certification

Best Informatica Interview Questions & Answers ... or answers of the Master Informatica Question ... Best Informatica Interview Questions & Answers
Read more

Informatica Interview Questions and Answers - Expertsfollow

Tutorials,Interview Questions,Answers Hadoop,tableau ... Ask Question; Account. Remember ... What are the limitations for bulk loading in informatica for ...
Read more

100 Informatica Interview Questions you should know ...

Here I have collected some qood interview questions with answers about Informatica ... 100 Informatica Interview ... answers ; 40 Basic MySQL Interview ...
Read more

Informatica Interview Questions and Answers - Intellipaat

Frequently asked Informatica Interview Questions with detailed answers and ... Informatica Interview Questions with ... forms in visual basic.
Read more

Informatica ETL Interview Questions and Answers – Part 1 ...

Informatica Interview Questions & Answers: A. What are the differences between Connected and Unconnected lookup? Connected lookup participates in the ...
Read more

Informatica Interview Question & Answers - ETL TOOLS

Important Informatica Interview Question ask's in ... This is also a basic STAR Schema which is the basic ... Informatica Interview Question & Answers;
Read more

Top 50 Informatica Interview Questions with Answers

... Home / Latest Articles / Data Analytics & Business Intelligence / Top 50 Informatica Interview Questions with Answers. ... can be created in informatica?
Read more