INFORMATICA INTERVIEW QUESTIONS AND ANSWERS PDF FORMAT
Download Complete Questions in PDF. It will be helpful for Informatica Interview questions and answers Some of those questions and their answers include: Your browser does not currently recognize any of the video formats available. Informatica Interview Questions and myavr.info - Download as Word Doc . doc /.docx), PDF File .pdf), Text File .txt) or read online. Informatica Interview Questions and myavr.info - Download as PDF File .pdf), Text File .txt) or read online.
|Language:||English, Spanish, Japanese|
|Genre:||Politics & Laws|
|ePub File Size:||19.82 MB|
|PDF File Size:||18.58 MB|
|Distribution:||Free* [*Regsitration Required]|
Frequently asked Informatica Interview Questions with detailed answers and examples. Tips and Tricks for cracking Informatica interview. Happy Informatica job. Do you want to download the question-answer set in PDF format for offline study? If yes, get the Master Informatica Question Answer Set. Informatica Interview Questions | Advanced Technical Topics | For freshers & Professionals | Free Informatica Interview Questions And Answers in the Lookup transformation like for example flat file, relational tables, synonym or view etc.
Reusable transformation is used numerous times in mapping. It is different from other mappings which use the transformation since it is stored as a metadata.
The transformations will be nullified in the mappings whenever any change in the reusable transformation is made. What does update strategy mean, and what are the different option of it? Row by row processing is done by informatica. Every row is inserted in the target table because it is marked as default. Update strategy is used whenever the row has to be updated or inserted based on some sequence.
Moreover the condition must be specified in update strategy for the processed row to be marked as updated or inserted. What is the scenario which compels informatica server to reject files? Moreover it disrupts the database constraint filed in the rows was condensed. What is surrogate key? Surrogate key is a replacement for the natural prime key. It is a unique identification for each row in the table. It is very beneficial because the natural primary key can change which eventually makes update more difficult.
They are always used in form of a digit or integer. What are the prerequisite tasks to achieve the session partition? In order to perform session partition one need to configure the session to partition source data and then installing the Informatica server machine in multifold CPU's. Which files are created during the session rums by informatics server?
During session runs, the files created are namely Errors log, Bad file, Workflow low and session log. Briefly define a session task? It is a chunk of instruction the guides Power center server about how and when to transfer data from sources to targets.
What does command task mean? This specific task permits one or more than one shell commands in Unix or DOS in windows to run during the workflow. What is standalone command task? This task can be used anywhere in the workflow to run the shell commands. What is meant by pre and post session shell command? Command task can be called as the pre or post session shell command for a session task. One can run it as pre session command r post session success command or post session failure command.
What is predefined event?
It is a file-watch event. It waits for a specific file to arrive at a specific location. How can you define user defied event? User defined event can be described as a flow of tasks in the workflow. Events can be created and then raised as need arises. What is a work flow? Ans: Work flow is a bunch of instructions that communicates server about how to implement tasks.
Informatica Training & Certification
What are the different tools in workflow manager? Following are the different tools in workflow manager namely Task Designer Workflow Designer Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
A method by which multi-dimensional analysis occurs. What are the different types of OLAP?
Give an example? ROLAP eg.
What do you mean by worklet? When the workflow tasks are grouped in a set, it is called as worklet. Workflow tasks includes timer, decision, command, event wait, mail, session, link, assignment, control etc. What is the use of target designer? Target Definition is created with the help of target designer. Where can we find the throughput option in informatica? Throughput option can be found in informatica in workflow monitor. We have the following types of Lookup.
Relational or flat file lookup. To perform a lookup on a flat file or a relational table. Pipeline lookup. Connected or unconnected lookup. A connected Lookup transformation receives source data, performs a lookup, and returns data to the pipeline.
An unconnected Lookup transformation is not connected to a source or target. A transformation in the pipeline calls the Lookup transformation with a: LKP expression. The unconnected Lookup transformation returns one column to the calling transformation. Cached or un-cached lookup. We can configure the lookup transformation to Cache the lookup data or directly query the lookup source every time the lookup is invoked.
If the Lookup source is Flat file, the lookup is always cached. Perform joins in a database when possible. In some cases, this is not possible, such as joining tables from two different databases or flat file systems. To perform a join in a database, we can use the following options: Create and Use a pre-session stored procedure to join the tables in a database. Use the Source Qualifier transformation to perform the join.
Join sorted data when possible For an unsorted Joiner transformation, designate the source with fewer rows as the master source. For a sorted Joiner transformation, designate the source with fewer duplicate key values as the master source. What are the types of Caches in lookup?
Top 50 Informatica Interview Questions & Answers
Explain them. Un- cached lookup— Here, the lookup transformation does not create the cache. For each record, it goes to the lookup Source, performs the lookup and returns value. So for 10K rows, it will go the Lookup source 10K times to get the related values.
Cached Lookup— In order to reduce the to and fro communication with the Lookup Source and Informatica Server, we can configure the lookup transformation to create the cache. In this way, the entire data from the Lookup Source is cached and all lookups are performed against the Caches. Based on the types of the Caches configured, we can have two types of caches, Static and Dynamic. The Integration Service performs differently based on the type of lookup cache that is configured.
The following table compares Lookup transformations with an uncached lookup, a static cache, and a dynamic cache: Persistent Cache By default, the Lookup caches are deleted post successful completion of the respective sessions but, we can configure to preserve the caches, to reuse it next time. Shared Cache We can share the lookup cache between multiple transformations.
We can share an unnamed cache between transformations in the same mapping. We can share a named cache between transformations in the same or different mappings.
We can use the session configurations to update the records. We can have several options for handling database operations such as insert, update, delete. Insert: — Treat all rows as inserts. Delete: — Treat all rows as deletes. Update: — Treat all rows as updates. Ans: 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. Q 16 How can we use Batches? Ans: 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.
Q 17 What is Mapping?
Top 64 Informatica Interview Questions with Answers
Ans: 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. Q 18 What is Transformation? Ans: 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.
Q 19 What is Expression Transformation? Ans: 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? We can set a conditional Logic within the Update Strategy Transformation to tag it.
Q 21 What is Sorter Transformation? Ans: 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.
Informatica Interview Questions and Answers.pdf
Q 22 What is Router Transformation? Ans: 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? 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.
Rank Transformation identifies each row from the top to bottom and then assigns Rank Index.Hash Auto-keys partitioning - The hash auto keys partition is used by the power center server to group data rows across partitions.
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. It is very beneficial because the natural primary key can change which eventually makes update more difficult. Competition is high due to its scope in future.
For the purpose of creating indexes after the load process, command tasks at session level can be used. Delete: — Treat all rows as deletes. It has got a simple visual interface like forms in visual basic.
- CONSTRUCTION DRAWINGS AND DETAILS FOR INTERIORS PDF
- 10TH STANDARD TAMIL TEXT BOOK
- CHARCUTERIE THE CRAFT OF SALTING SMOKING AND CURING PDF
- HEIZER AND RENDER OPERATIONS MANAGEMENT PDF
- PERSONALITY DEVELOPMENT BY SWAMI VIVEKANANDA PDF
- AGENT-BASED AND INDIVIDUAL-BASED MODELING A PRACTICAL INTRODUCTION PDF
- HANDBOOK OF ELECTRIC MOTORS PDF
- MODERN SYSTEMS ANALYSIS AND DESIGN PDF
- PDC BY ANAND KUMAR PDF
- MANAGING ONESELF DRUCKER PDF
- ENTITY FRAMEWORK 4 IN ACTION PDF
- AGATHA CHRISTIE EPUB COLLECTION
- NITRO PDF HIPPO
- REFLECTED IN YOU PDF
- NCERT 7TH CLASS SOCIAL SCIENCE BOOK