Informatica Interview Questions Pdf Free Download

Related image
Informatica free practice questions lets you to boost your confidence on nuances of informatica techonology.A great place for you to enhance your knowledge. Most Frequently asked Informatica Interview Questions and Answers: This article is covering the top Informatica MDM, PowerCenter, Workflow Manager, Workflow Monitor, Designer etc.

Below are the Top 100 Questions in Excel format. Kindly scroll Left to Right to View the answers and scroll down for more questions.

Question	Option 1	Option 2	Option 3	Option 4	Option 5	Correct Answer
What type of tool is Informatica?	ETL	OLTP	OLAP	Reverse Engineering	Data Modeling	1
Which database does not support user-defined return values?	Sybase	Oracle	Informix	SQL Server	Teradata	3
What is cache?	An area in Source database	An area in Target database	An area in Repository Server	An area in Informatica Server	An area in Memory	5
Which of the following are join types are there in informatica?	Normal	Master Outer	Left Outer	Exclusive Outer	Right outer	1,2
In ASCI I mode for each character, how many bytes are required	1 byte	2 bytes	3 bytes	4 bytes	1 bit	1
Comparing with Informatica power center 5.1 and 6.1 version, in 6.1 version, which transformations have been newly added?	Lookup & Union	Sorter and sequence	Transaction control & Sorter	Sorter & Union	Filter	3
XML stands for	Extended Mainframe Language	Extended Markup language	Enhanced Mainframe Language	Enhanced Markup Language		2
Which types of data movement modes does Informatica server supports?	ASCII	Unicode	Binary	Decimal	Hexadecimal	1,2
In what version of Informatica FlatFile Lookup Is available.	Infa 5	Infa 6	Infa 7	All The Above		3
Which one of these are not terminologies related to Informatica	Drill down	Dimension	Mapping	Workflow	Session	2,3,4,5
Which of the following terms are applicable for Datawarehousing?	OLAP	OLTP	Dimension	Cube	Fact	1,3,4,5
What are the types of extractions available?	Full Extraction	Progressive Extraction	Incremental Extraction	Big Bang Extraction	Slow Extraction	1,3
Where is the Source and Target information stored?	Repository Server	Informatica Server	Specific Folder	Repository Database	Source and Target Database respectively	4
Informatica server holds two different values for a mapping Variable. What are they called as?	Start value/End value	Start Value/Current Value	Start Value/Persistent Value	Start Value/Active Value	No values are held	2
Where will the Informatica server store data until it completes Aggregate calculations?	Memory	Repository Server Cache	Database	Cache	Informatica Server Cache	3
Characters in the parameter file must be a subset of	Repository server code page	Information Server code page	Repository agent code page	Informatica client code page	Database Server Code Page	2
Informatica Server uses the following environment variable defined on the server plat form to locate the dynamic link library or shared object on window operating server	PATH	LD_LIBRARY_PATH	SHLIB_PATH	LIBPATH	LOGPATH	1
What will happen if the maximum number of sessions are reached	The new sessions enter into a queue and are run one by one	Failure or queuing can be controlled by another option	All the sessions will fail	All new sessions will fail	Server goes to a sleep mode untill sessions are manually terminated	2
What will happen if the maximum number of sessions are reached
What are different ways Null can be handled by Informatica in comparisons?	Null cannot be used for comparisons	Treated as Null	Treated as a Low/High value	Determined at runtime	Determined by the database	2,3
By enabling the Enhanced security option, the following permissions are provided	Read/Write	Append	Execute	Overwrite	Override	1,3
External Stored procedure transformation object resides at	Repository Server	Informatica Server	Repository Database	Informatica Client Machine	Database where Stored Procedure is present	3
Which of the following are the security options not avaialble in Repository Manager?	Manage Users	Manage Groups	Manage Folders	Manage Privileges	Manage Repository	3,5
Which of the following are false about Metadata Extensions	It is not a property of the object in which it is created	It appears on the Metadata extension tab of the each object of that type created	Metadata extension names need not be unique for each type of object in a domain	The datatype could be numeric (integer), string, or boolean	Metadata extension names must be unique for each type of object in a domain	1,3
By default how does the Informatica server treat NULL values in aggregator functions?	Zero	NULL	Will throw an error message	Zero for Numeric, NULL for String variable		2
Where will you set the type of Update for an Update Strategy transformation?	In session	In mapping	In repository	In workflow	In task	2
Which of the following properties belong to update strategy transformation	Variable	Forward rejected rows	Data driven	Tracing	SQL Override	2,4,5
If the lookup table is not changed in between sessions which cache is better to use?	Static	Index	Persistent	Dynamic	Cached	3
If lookup transformation uses dynamic cache which operator we can use in lookup condition?	=	>=	<=	=>'	=<'	1
What will happen when the Informatica Server encounters multiple matches for a dynamic Lookup transformation	It returns all the results	It returns the first matching value	It returns an error	It returns the values one by one sequentially	Duplicate data will be deleted in the lookup table	3
What will happen if this condition is given as a filter condition? IIF(ISNULL(FIRST_NAME),FALSE,TRUE) (Assume FIRST_NAME is a column in a Database table)	All rows that have FIRST_NAME as NULL are filtered	All rows that do not have FIRST_NAME as NULLare filtered	Will result in an error when mapping is validated	All rows will be filtered	No rows will be filtered	1
What is the default Sorter Transformation Cache size	2000000 bytes	4000000 bytes	8000000 bytes	16000000 bytes	0 bytes	3
We use the Update Strategy transformation before or after the lookup, to flag rows for _____ to the target	Insert	Update	Append	Reject	Override	1,2,4
When the stored procedure transformation is after the joiner transformation, the informatica server uses the database connection of the	Detail table	Master table	Target table	1 or 2 (If existing in both the DBs, Master will be used)	2 or 3	2
All rows of data from the detail source and the matching rows from the master source are selected.This type of join called as?	Master-Outer	Normal	Detail-Outer	Full-Outer	Inner-Join	1
From the below which transformation cannot be reusable?	ERP Source Qualifier	Dynamic lookup cache	Sequence Generator	Aggregator		1
Where do you configure the Index and data cache of Aggregator transformation?	Session properties	Aggregator transformation	Mapping properties	Changes can be made using Designer or Workflow Manager tool	Paramater Variables	1,2,4
Which of the data type is preferable when making comparisons using lookup And filter transformations?	Date	DateTime	Integer	String	Char	3
Find out the Active transformations?	Expression	Filter	Lookup	Aggregator	XML Source Qualifier	2
Find out the Passive transformation?	Source Qualifier	Rank	Aggregator	Router	Filter	3
We Use the Normalizer transformation with COBOL sources which are often stored in?	Demoralized Form	Normalized Form	Hierarchical Form	Referential Form	Textual Form	1
Which transformation is designed to handle data read from COBOL sources	Union	Router	Advanced External Procedure	Normalizer	Filter	4
Assume your source table has a column EmployeeID, and you want to include the EmployeeName in your target. In this case which Transformation will you use? Assume mapplets are not used in this Repository	Update strategy	Stored procedure	Lookup	Joiner	Filter	3
What is the use of Variable port?	To improve the performance	To reduce time	To store intermediate results	To parameterise values in a mapping	Used in mapplets for reusability	3
Which of these groups are Router Transformation supported Groups?	Variable Group	User defined Group	Dynamic Group	Static Group	Custom Group	2
Which Transformation won't allow addition of any port?	Custom	Union	Sequence	Mid Stream XML Parser	Aggregator	3
What is the default join that Source qualifier provides?	Inner join	Outer join	Inner equi join	Inner non-equi join	Outer equi join	3
What is the default join in the joiner transformation?	Normal	Outer join	Inner	Full Outer	Exclusive	1
Which one is correct for the following example? The total commission of employees who exceeds their quarterly quota?	Sum (commission, commission > quota)	Sum (commission, commission >=quota)	Sum (commission, commission > quota=)	Sum (commission, commission => quota)	Sum (commission, commission <= quota)	1
If we do not set the cycle option in sequence generator what happens when it reaches maximum value?	Starts from initial value	Does not effect the session	Session fails	Decrements from maximum value	Mapping is invalidated	3
In my source there are two fields entry date and apply date i want to reject the data if the entry date is after the apply date for this which expression correct	IIF ((ENTRY_DATE >=APPLY_DATE), DD_REJECT, DD_Update)	IIF ((ENTRY_DATE <= APPLY_DATE), DD_UPDATE, DD_REJECT)	IIF ((ENTRY_DATE > APPLY_DATE), DD_REJECT, DD_UPDATE	IIF ((ENTRY_DATE =>APPLY_DATE), DD_REJECT, DD_Update)	IIF ((ENTRY_DATE =< APPLY_DATE), DD_UPDATE, DD_REJECT)	3
To verify the target tables and disk space on the target system, Stored procedure must be the type of	Source pre-load	Target pre-load	Source post-load	Target post-load	Source commit-load	2
What is the purpose of SQL Override in a Source Qualifier?	Joining 2 or more homogenous sources	Peform cross-platform joins	Joining 2 or more heterogenous sources	To change column order of source	To eliminate duplicate data	1
A transformation has the following ports: Port_1: String, Input port; Port_2: String, Input port; Port_3: String, Output port Which of the expressions shown below would be valid? Assume that it is associated with Port_3 and that the string ENDSTRING is no	Port_1\|\| Port_2 \|\| 'ENDSTRING'	Port_1 \|\| Port_2 \|\| "ENDSTRING"	Port_1 \|\| Port_2 \|\| ENDSTRING	CONCAT(Port_1, CONCAT(Port_2, "ENDSTRING"))		1
A transformation has the following ports: Port_1: Decimal, Input port; Port_2: Decimal, Input port; Port_3: String, Input port; Port_4: Decimal, Output port; Port_5: Decimal, Output port. Which of the expressions shown below would be invalid?	IIF ( Port_1 > 5, Port_2 * 10, Port_2 * 15 )	IIF ( Port_1 > 5, Port_1 * 10,Port_1 * 20)	IIF ( Port_5 > 7, Port_5 * 10, Port_5 * 15 )	IIF ( Port_2 > 8, Port_2 * 10, Port_2 * 15 )	IIF ( Port_3 > 8, Port_3 * 10, Port_3 * 15 )	5
When can we use a connected Lookup?	Does not support UserDefined Values	DynamicCache is possible	Returns MultipleColumns	DynamicCache is not possible	If rows are to be passed to a Filter or Router transformation directly	2,3,5
When using Mapping Designer, what are all the Transformations that cannot be used in a Mapplet?	Sequence Generator	Sources	Aggregator	Targets	Normaliser	1,4,5
How is the Pre and Post SQL Commands validated?	By the Designer	Cannot be validated	By the Workflow Manager	Validated when session is created	Validated at run time by Informatica Server	2
Baed on a flag (0 or 1) either Insert or Update has to be done on a Target. What are the ways in which this can be best achieved?	Use Router Transformation	Use Filter Transformation	Group the data using Aggregator and send to target	Use Update Strategy and use the flag for setting the condition as DD_UPDATE or DD_INSERT	Write two mappings and filter data using source qualifier	1,4
._____means the row will not have SQL Written for it	DD_INSERT	DD_REJECT	DD_UPDATE	DD_DELETE	DD_APPEND	2
Which of the following properties you can change for a newly added Source column without invalidating a mapping:	Data type	Table Name	Redefines	Key constraints	Column Name	1,3,4
When you import the Source definition, which of the following source metadata you import?	Source name	Triggers	Column Names	Key Contraints	Indexes	1,3,4
When you import a COBOL source, the Designer scans the file for which of the following components?	Target	Source	Redefines	Fields	Occurs	3,4,5
You can create Transformations in designer using	Mapping Designer	Source Analyzer	Mapplet Designer	Transformation Developer	Warehouse Designer	1,3,4
Which of the following are tools of Designer?	Source Analyzer	Session Developer	Task Developer	Warehouse Designer	Mapping Designer	1,4,5
Designer is used for	Creating source and target definitions	Creating mappings	Create Folders and set privileges	Creating Mapplets	Creating Sessions and Workflows	1,2,4
Jumping from one transformation to any other transformation using the debugger can be done using	Step to instance	Next instance	Break points	Forward instance	Break to Instance	1
Sources do not contain	Input ports	Output ports	Variable ports	Sorted ports	Metadata Extensions	1,3,4
Update the row if it exists,otherwise insert it.Which option is suitable for this one	Update as update	Update as insert	Delete	Insert	Update as update/Insert as Insert	5
Which of the following tasks can we perform in the designer?	Create shortcuts	Export/Import Registry	Export and Import repository objects	Copy objects	Compare Folders	1,2,4
If the object is Target, then what are the dependencies that are displayed when "View Dependencies" is selected for it?	Target within the same folder that reference the target through a foreign key relationship	Shortcuts to the target	Mappings using the target	Mapplets using the target	Sources that are dependent on the target	1,2,3
I used a Sequence Generator in a mapping and I have done some testing on this particular mapping.In this particular Scenario, how I can set the sequence Generator to its Initial value?	Set the current value to 1	Remove from mapping and recreate	Cannot be reset	1,2	2,4	4
Variable ports are not visible in_____view	Normal	Edit	Debug	Read-only View	Full-screen View	1
----' is a set of source and target definitions linked by transformation Objects that define the rules for transformation	Session	Mapping	Workflow	Worklet	Batch	2
What is Slowly changing dimensition?	To manage the data	To manage the mapping	To manage the workflow	To manage the Session	To manage Workflow monitor	1
How many types of techniques are there for SCD?	1	2	3	4	5	3
What is the default source option for update strategy transformation	Insert	Update	Delete	Data driven	Reject	4
The Designer includes a "Find" search tool as part of the standard toolbar.What can be searched using the tool?	Persistent Values	Port Names	Source Definitions	Target Definitions	Descriptive Text	2,3,4
If a source is imported form a databases what all can be configured?	Owner Name	Database Type	Constraint Name	Index Name	Database Name	1,2,5
If a target is imported form a databases what all can be configured?	Constraint Name	Database Type	Index Name	Business Name	Nullability	2,4,5
A -------- is a set of transformations that you build in the Mapplet Designer and can use in multiple mappings	Session	Mapping	Workflow	Mapplet	Batch	4
Which of the following is not possible while copying/moving columns from one source to another without connecting to database	Create a shortcut and rename it	Cannot be copied	Use the Copy columns option	Drag and drop columns into the new source	Use the Move columns option	1,2,4
Repository manager is not used for	Creating Sessions	User Administration	Creating Folders	Folder Administration	Creating Mapping	1,5
Where is the cache (lookup, index) created?	Cache directory	Informatica Repository	Session Logs directory	Workflow Logs Directory		1
Which of the following is true about Advanced external procedures	AEP transformations are connected transformations	AEP transformations cannot be referenced in an expression	AEP transformations can be referenced in an expression	AEP transformations are un-connected transformations	AEP can be created only using Transformation Developer	1,2,5
Disabling of high precision for numeric data converts data to which data type?	Integer	Decimal	Char	Double	Date	4
What happens to the session if the commit interval is too high and Informatica server fills the database log file?	Session waits for the Log to be cleared	Does not affect the session	Session fails	Session resumes once the log is cleared	Informatica Server hangs	3
Default location of the parameter file is	$PMSourceFileDir	$PMCacheDir	$PMSessionLogCount	$PMSessionLogDir	$PMBadFileDir	1
Config object tab in a session properties includes ____ settings	Commit	Load	Reject	Commit on Insert	Commit on Update	1,2
Which tracing level of Informatica Server logs 1. Initialization 2. Error message and 3. Notification of rejected data	Normal	Verbose Init	Verbose data	Terse	Descriptive	4
Workflow manager displays a _______ Invalid Icon if the worklet instance in the Workflow is invalid?	Red	Blue	Yellow	Green	Black	2
You want to use the same session to extract transaction records for each of your customers individually. Which way is preferred?	Create a mapping parameter to represent a single customer account	Create individual sesion for each customer account	Create individual mappings and sessions for each customer account	Create mapplets	Create mapplets and worklets for re-using	1
Which of the following is not applicable for CONTROL task in workflow manager?	To send e-mails when session fails	To stop the workflow that is running	To send alerts to the Notification Window	To fail a workflow that is running	To check the performance of session	1,3,5
Which of the following is applicable for COMMAND task in workflow manager?	To check the performance of session	Allows Batch File to be executed	Allows Unix command to be executed	To send alerts to the Notification Window	Allows shell scripts to be executed	2,3,5
Which Threads are created in DTM process?	Master	Input, Output	Transformation	Mapping	Reader	1,2,4,5
Whether or not a Session Task can be considered to have heterogeneous targets is determined by	The Mapping properties alone	The Session Task properties alone.	Either the Mapping properties or the Session Task properties	Either the Mapping properties or the Workflow properties.	Either the Mapping properties or the Workflow properties or Session Properties	2
How can we compare the mapping and mapplets of the same name belonging to different folders?	Mapping Designers	Mapplet Designers	Cannot be compared	Only by using a Repository Manager Compare	Workflow Manager	1,2
Which of the following tasks are re-usable?	Command	Control	E-mail	Session	Timer	1,3,4
Worklet variables are not used for	Reference values	Record information	Performance Tuning	Database Comparisons	Storing metadata extensions	3,4,5
Which of the following are applicable for Resuable tasks	Task instance can be edited using workflow designer	changes made to an instance is only applicable to the instance	changes made to an instance is propogated to the original task	Once an instance property is changed, the changes cannot be reverted	An instance property if changed, can be reverted	1,2,5
User defined worklet variables cannot be ______	Static	Dynamic	Persistent	Non-Persistent	Volatile	1,2,5
Which of the following objects you cannot include in a mapplet?	Filter	XML Sources	Normaliser	Aggregator	Target Definitions	2,3,5
I selected sorted input option but workflow takes same amount of time as before. What all could be the reason for this?	Aggregator expression contains nested aggregate functions	Source uses Incremental aggregation	Source data is data-driven	Source data has lesser data	Source has lesser columns	4
The number of threads depends on the ________ information for each pipeline?	Partition	Expression	CPU bandwidth	session	workflow	1
Where will the Informatica server stores data until it completes Aggregate calculations?	Memory	Repository	Database	Cache	log dir	3
Which data type is preferable when making comparisons using lookup and filter transformations?	Decimal	Double	Integer	char	varchar	3
To improve the session Performance which one has to be done?	Increase the no of partitions	Always use Verbose Tracing	Use only Normal load	Use ODBC for loading huge data	Avoid staging area	1,5
What is the order of identifying performance bottleneck	Source->Target->Mapping->Session->System	Target->Source->Mapping->Session->System	System->Source-> Target->Mapping->Session	Mapping->Session->System->Source->Target	Mapping->Session->System->Target->Source	2
To increase the performance of target load which one we have to do?	Use External load	Use Normal load	Decrease checkpoint intervals	build indexes	to enable cache	1
In lookup transformation which cache we have to use to improve session Performance?	Shared cache	Persistent cache	Recache from db	1 &2	1 & 3	1,2
There are three lookup cache counters having numbers 2000,4000,10000.Which of the following is true?	Tuning the lookup having counter 2000	Tuning the lookup having counter 10000	Tuning the lookup having counter 4000	All of them have the same performance	Disabling cache will improve performance	2
For a lookup on a small set of unchanging values which functions will degrade Session performance?	IIF	Is Null	Decode with single condition	Not NULL	Decode with multiple conditions	1,2,4
I have a table employee. I want the data only of deptno 10 using filter. To improve session performance where will I place the filter transformation?	Nearer to Target	After the lookup	Near to source	In the middle	Before the lookup	1
Which one will optimize Aggregator transformation?	Group by simple columns	Use sorted input	Use incremental aggregation	Use lookup	Use cache	1,2,3
If your Target consists key constraints and indexes that will slow the loading of data, to improve the session performance, what you will do?	Trace Level should be Verbose Init	Drop indexes before load	Drop table and re-create	Drop constraints before load	Trace Level should be Verbose	2,4
To run the informatica server which data movement you prefer?	ASCII	Unicode	Binary	EBCDIC	Decimal	1
Which of the following are types of lookup cache?	Non-volatile cache	Recache from database	Static cache	Dynamic cache	Volatile Cache	2,3,4
Which of the following is applicable in Sources with respect to File sources	Fixed-width file is supported	De-limited file is supported	No header should exist in a file	One source can act as placeholder for multiple sources	Escape character should always be / for delimited files	1,2,4
What components of a datawarehouse can you create using informatica	Cubes	Dimensions	Attributes	Levels	Marts	1,2,4
For which of the following transformations you will use Sorted Ports option to improve performance?	Source	Rank	Aggregator	Target	Joiner	2,3,5