*****************Informatica ****************************************

1. Number of log files by default in Infa?

a. 1
b. 2
c. 3 (session log, workflow log, reject log)
d. 4
e. 5
2. Which window helps to access the Repositories ?
a. Navigation Window
b. Property Window
c. Workflow Monitor
d. Workflow Manager
3. The primary server process in the infa Server?
a. Repository Manager
b. Load manager
c. Workflow manager
d. Workflow Designer
4. Which transformation helps to convert the rows into columns?
a. Rank Transformation
b. Sorter Transformation
c. Normalizer Transformation
d. Update Strategy
5. Which transformation row updates distinct records into target table?
a. Update Strategy
b. Rank
c. Sorter
d. Aggregation
No. of components in the Workflow Manager
e. 1
f. 2
g. 3
h. 4
i. 5
6. Writing scripts to schedule Workflows … what mode is this
a. Interactive mode
b. Command line mode
7. User, Groups, Privileges are created in which client tool?
a. Repository manager
b. Workflow Manager
c. Workflow monitor
d. Designer
8. What types of data sources are there in Infa? (all the options are correct but we had to
select only one option)
a. Flat files
b. Homogenous and heterogeneous sources
c. Flat files, Homogenous and heterogeneous sources
 d. XML and Cobol sources
e. None of the above

7)In pmcmd mode for each line you need to communicate with ------------

[Link] server

[Link] manager

[Link] manager

[Link] monitor

14) minimum number of transformations required to validate a mapping?

a.2

b.3

c.4

d.5
1. Number of tools in informatica designer. Ans 5
2. Number of ports in expression transformation. Ans 3
3. What are the servers in informatica?
a) Informatica server
b) Informatica repository server
c) Informatica server and informatica repository server
d) None of the above
I guess answer is (a) option
5. To operate in which pmcmd mode, username, password and server connection
details are necessary?
a) Commandline
b) Interactive
c) Both
d) None
6. To determine which column caused the row to be rejected, what does the server
add to give more info about columns?
a) Key indicators
b) Key breaks
c) Row indicator and column indicators
d) Variable indicator
7. What transformation should be used to get the values related to deptno 10 only in
the target table?
a) Filter
b) Router
c) Filter and router
d) Source qualifier and filter
 e) Source qualifier, filter and router
Guess ans is (a)
8. Where do you create folders and give connection details?
a) Repository manager
b) Workflow manager
c) Designer
9. when you create a workflow which task gets created by default?
a) Start
b) Command
c) Assignment
d) Timer
I marked (a). Not sure
10. latest version of Power center can handle
a) 124 bit
b) 64 bit
c) 32 bit
d) 128 bit
2)Before you connect to the informatica server you must register it with?
a) Repository mamager
5) using pmcmd you connect to?
a)Workflow manager
6)pmcmd is used to connect with?
a)Powercentre or informatica server or powermart whichever you find as the answer there
7) In where can you prepare a reusable transformation
a)transformation designer
8)Where in Informatica will the business logics be applied
a)Transformation Developer
9)What will you use to to join an RDBMS input file and an XML file
a)Source Qualifier and Union( I am not very sure of this)
10)When you use update trategy trasnformation which is the default mode?
a)Insert
11)Where is that you design tasks so that it runs sequentially or in some order defined?
a)Workflow designer
3. While running workflow informatica server gets connection with
a. Repository server.
b. Workflow Manager.
c. Workflow Monitor.
d. Repository Manager
6. Email to customers.
a. Email individual
b. Put in public folder
c. bursting
How many modes in pmcmd
a) 1
b) 2
c) 3
d) 4
what do mean by nesting
a) one dimension above to another
b) one dimension below to another
c) one dimension next to another
which transformation is used to reject load files
a) source qualifier transformation
b) router transformation
c) either source qualifier nor router
b) source quailifier,router and filter transformation
How many transformation are there ?
a)12
b)16
c)8
b)13
what do u mean parent fails current task fails
a) current task fail if parent fail
b) parent fail if the current task fail
c) current task only fail
d) both current and parent fail
which should be used to define a interval between two task
a) set wait
b) set no wait
c) wait
Look up transformation syntax
1. A developer wishes to use the data previewwe to determine the total number of rows in a
relational source table. The number of rows exceeds [Link] is the proper procedure
for this operation?
a. Connect the data Previewer to the source table with all settings left to the defaults.
b. Connect the data Previewer to the source table and check the option “Count rows”
c. This operation is not supported because the number of rows exceeds 10000. It is
supported only when number of rows is 10000 or less.
d. This operation is not supported.
2. How many repositories can you simultaneously work in a single Designer environment?
2 repositories
4. Under what circumstances can a Target definition be edited from the Mapping
Designer ,within the mapping where that Target definition is being used ?
[Link] the Target definition is not shared(not a shortcut)
[Link] the Target definition is not shared(not a shortcut) and when the user has write
permission on the folder where the mapping is stored
[Link]
[Link]
5 .A User desires to join two relational sources with a single Source Qualifier have been
correctly imported into the mapping . Next, she must establish a primary/foreign key
relationship between two ports in the source definitions. Assuming that the relationship does
not currently exist on the database server,what are the required steps to do this?
a. Use the source Analyser to establish that primary/foreign key relationship and save the
repository
b. Use the source Analyser to establish that primary/foreign key relationship,save the
repository,and run the appropriate SQL statement on the database tables t ocreate the actual
primary / foreign key relationship
[Link] the source Analyser to establish that primary/foreign key relationship,open the
SQL Editor in the Source qualifierand generate the join statement,modify the join
statement is required and save the repository.
d. Use the source analyzer to establish that primary /foreign key relationship , regenerate the
source Qualifier SQL using the SQL editor,press the okay button and save the repository.
RNK
AGG
1. What types of data sources are there in Infa? (all the options are correct but we had to
select only one option)
a. Flat files
b. Homogenous and heterogeneous sources
c. Flat files, Homogenous and heterogeneous sources
d. XML and Cobol sources
 e. None of the above
7. In informatica, you can create a shortcut to the folder by checking the checkbox:
 Allow shortcut
 Create shortcut
 Shortcut
 Folder shortcut
8. Worklet contains a set of
 Mappings
 Tasks
 Sessions
 Mapplets
9. Which task is used to send an email after the workflow is completed
 Event
 Command
 Email
 timer
10. Using which transformation can you update distinct records into the target table.
 Filter
 Router
 Update strategy
 Sequence generator
11. Which command is used to call a transformation from lookup to expression
 LKP:Lookup….
 Some options like this
26. The primary server process in the infa Server?
a. Repository Manager
b. Load manager
c. Workflow manager
d. Workflow Designe
27. Writing scripts to schedule Workflows … what mode is this
a. Interactive mode
b. Command line mode
[Link] of surrogate keys
Ans:improve performance
[Link] which SCD we use different surrogate keys
Ans: none
3: no of permissions in folder(infa)
Ans: 7
4: timeout in repository manager(infa)
Ans: 60 secs
Which repository objects is not created in Workflow Manager ?
Explanation:

a. Database connections
b. Worklet
c. Maplet
d. Session

Which repository objects are created by repository manager?

Explanation:

a. Folder
b. Users
c. User groups
d. User type

Which statement is true?

Explanation:

a. A repository domain consists of no of global repository and any number of local repositories
b. A repository domain consists of a single global repository and any number of local
repositories
c. A repository domain consists of no of global repository and one local repositories
d. non of these

Which is not a versions of objects in the repository?

Explanation:

a. Check out and check in versioned objects

b. Compare objects
c. Track changes to an object
d. Update a version

Where you can release lock if one object is locked?

Explanation:

a. Work flow manager

b. Designer
c. Repository Manager
 d. Non of these

If you are comparing two date using date_compare function , if first date is earlier then what
will be returned?
Explanation:

a. date difference in number

b. date difference in no of day
c. -1
d. 1

If you are comparing two date using date_compare function , if Second date is earlier then
what will be returned?
Explanation:

a. no of days in number
b. no of days in days
c. 1
d. 0

If you are comparing two date using date_compare function , if two dates are equal then
what will be returned?
Explanation:

a. 1
b. -1
c. 0
d. null

INSTR( "I am a informatica Developer', 'a', 1, 2 ) What is out put?

Explanation:

a. 3
b. 4
c. 5
d. 6

INSTR( "informatica', 'a', -1, 2 ) What is out put?

Explanation:
 a. 5
b. 7
c. 12
d. 1 (wrong)

What will out put? SUBSTR( "Informatica",1,INSTR( "Informatica",1,1 ))

Explanation:

a. I
b. atica
c. tica
d. Informa

LEAST( 12, 13, 21 ) what will output?

Explanation:

a. 46
b. 25
c. 12
d. 21

LPAD( 190, 5, '0') What will output?

Explanation:

a. 00000190
b. 19000000
c. 00190 (correct)
d. 19000

LPAD( "Informatica", 16, '*..*' ) What will output?

Explanation:

a. *..*Informatica
b. *..*.Informatica
c. Informatica*..*.
d. Informatica*..*

LPAD( "Inform", -10, '*') What will out put?

Explanation:
a. Inform*****
b. *****Inform
c. Inform
d. null
 CORRECTED INFORMATICA MCQ (CHN16DW001 BATCH)
1. Informatica version cannot be upgraded- FALSE
2. CONTROL task is a reusable task- FALSE
3. View details about a workflow/task in- Gnatt Chart View
4. Admin Console is web-based- TRUE
5. Choose Informatica key features- All of them
6. Which are the caches available in Informatica- Static, Dynamic & Persistent
7. Where to import target table- Warehouse Designer (also called Target
designer)
8. Objects are copied in- Mapping designer & Mapplet designer
9. Can we update the target without using update strategy- Yes
10. Which options are true about Union transformation:
a. You can create input groups
b. You can rename the transformation
11. Tool where mapping is created- Mapping Designer
12. Worklets can be used in workflow- True
13. In session log, which information we can find-
a. Error information
b. Load summary
14. Choose ETL Tools:
a. Oracle Warehouse Builder
b. Informatica
c. Business Object
15. How to select distinct records from Source Qualifier-
Choose ‘Select distinct’ option
16. Sessions are created in which tool- None of the listed option (Correct
ans is task developer/workflow designer)
17. Importing & exporting of objects is done in- Mapping designer
18. External loader is one of the connection type- True
19. To run a session what is required-
a. Workflow
b. Integration service
20. Choose transformation that merges data from different systems- Joiner
(heterogeneous sources)
21. Integration service can be selected at Workflow level- True
22. Repository objects can be exported to- XML FILE
23. Whether a session task can contain heterogeneous targets, is
determined by-
Either mapping properties or session task properties
24. Aborting workflow from workflow monitor is not possible- FALSE
25. Session has to run from Monday to Saturday, not on Sunday. How to
schedule it in Informatica- Use customized repeat option
26. How many tasks can be created in task developer- Multiple
27. Session performance can be improved by-
a. Partitioning
b. Push-down
28. Type of logins in informatica-
a. Native
b. LDAP
29. Mapplet feature-
Allows you to reuse the transformation logic in multiple mappings
30. Repository server manages:
a. Repository agent process
b. Monitors running repository agent
c. Repository connection requests
1.Port_1:string,input port;Port_2:string,input Port;Port_3:string,output [Link] that is associated
with port3 and the string END STRING is not a variable.

ANS: port1||port2||'ENDSTRING'

2. Source-target information is stored in

ANS: Repository Database.

3. where does Informatica stores data until it completes aggregate calculation.

ANS: Database

[Link] Join that a source qualifier provides.

ANS:Inner Eqi Join.

[Link] from one transformation to any other transformation using debugger can be done using

ANS: Break Point.

[Link] Manager is not used for

ANS:[Link] Session
[Link] Mapping

[Link] use connected look up

ANS:

8. Row will not have Sql written for it

ANS: DD_Reject

9. Number of threads depend on _____________ information pipeline

ANS:Partition

10. Where will you set the type of update for in update strategy Transformation.

ANS: Session or Mapping

[Link] A Look up table is not changed in between session, which cache is better to use?

ANS: Persistant

12. Forms Appropriate for dataware housing

ANS:OLAP

[Link] of SQL override in SQL qualifier.

ANS:Joining 2 or more homogenous sources, filtering unneccessary data, Change column order source.

[Link] support user defined return values.

ANS:Informix.

[Link] that load manager doesnot perform.

ANS:Locking and Reading session.

[Link] a look up on a small set of unchanging values which functions will degrade session performance.

ANS: Not Null, Is Null, IIF.

[Link] many bytes are required for each character.

ANS:1 BYTE

18.____________ will aggregator transformation.

ANS: Incremantal aggregator transformation, sorted input, group by columns.

[Link] object is target then wat are the dependancies that are displayed when 'view dependanceies'.

ANS: Sources that are dependant on target.

mapping using target.
Shortcut for target.

[Link] options available in repository manager.

ANS: privileges, groups, users.

[Link] transformations in designer using

ANS: Mapping designer

Mapplet Designer
Transformation developer

[Link] we use normaliser transformation with COBOL sources often stored in

ANS: Denormaliser form

[Link] included in Mapplet.

ANS: Normaliser,XML sources, target definitions.

[Link] source option for update startegy transformation

ANS: Data Driven

[Link] Types

ANS: 3

[Link] is cache created.

ANS: Cache directory.

[Link] sources with respect to file sources

ANS:Fixed width file is supported, delimited file is supported , one source act as place holder for multiple
sources.

[Link] of variable port.

ANS: It is used to store intermediate result.

[Link] Employee table, we have to get only the emp id = 10. where will we place look up.

ANS:Near the Source.

[Link] can a task get fail in a workflow

Ans: fail me , fail parent task if current task fails.
RED: ANSWER, BLUE: IMP QUESTIONS
------------------------------------------------------------------------------------------------------------------------------------------

Can you connect ports of two output groups, from router transformation to a single target definitions?

Explanation:

Yes

No

-----------------------------------------------------------------------------------------------------------------------------------------

_________ Server governs the implementation of various processes among the factors of server’s
database repository.

Repository server

Temp server

*Powerhouse server

Domain server

-----------------------------------------------------------------------------------------------------------------------------------------

Can one use mapping parameter or variables created in one mapping into any other reusable
transformation?

*YES

NO

-----------------------------------------------------------------------------------------------------------------------------------------

Which type is NOT used in metadata stored in repository?

Source Definition

Mappings

Mapplet

*Applet

-----------------------------------------------------------------------------------------------------------------------------------------

Can you validate all mappings in the repository simultaneously?

YES

*NO

-----------------------------------------------------------------------------------------------------------------------------------------
Which transformation is used to combine data from different sources?

Joiner transformation

Lookup transformation

Union Transformation

Expression transformation

-----------------------------------------------------------------------------------------------------------------------------------------

Which transformation is used numerous times in mapping?

Reusable transformation

Union Transformation

Lookup transformation

Expression transformation

-----------------------------------------------------------------------------------------------------------------------------------------

Which task is used anywhere in the workflow to run the shell commands?

Command Task

Session Task

Standalone Command Task

Email Task

-----------------------------------------------------------------------------------------------------------------------------------------

OLAP stands for?

On-Line Analysis Processing

On-Line Analytical Processing

On-Line Access Processing

On-Line Application processing

-----------------------------------------------------------------------------------------------------------------------------------------

Which process is used for online analytical processing?

Data mart

Database

Data warehouse

Data
-----------------------------------------------------------------------------------------------------------------------------------------

In joiner transformation we override the query?

YES

NO

-----------------------------------------------------------------------------------------------------------------------------------------

Mappings can be validate simultaneously?

Yes NO

-----------------------------------------------------------------------------------------------------------------------------------------

You can compare [Link] targets 2. Two target shortcuts 3. Target with target shortcuts

-----------------------------------------------------------------------------------------------------------------------------------------

Informatica version can be upgraded

-----------------------------------------------------------------------------------------------------------------------------------------

Control is not reusable task

-----------------------------------------------------------------------------------------------------------------------------------------

View details about a workflow or task in Gantt chart view

Admin console is web-based

-----------------------------------------------------------------------------------------------------------------------------------------

Informatica key feature : Developer productivity, enterprise level data integration, scalability

-----------------------------------------------------------------------------------------------------------------------------------------

Static ,dynamic ,persistent Cache used in Informatica

-----------------------------------------------------------------------------------------------------------------------------------------

(*not found) Integration service can be selected as workflow level: True

-----------------------------------------------------------------------------------------------------------------------------------------

Full Outer Join keeps all rows from master and detail sources

-----------------------------------------------------------------------------------------------------------------------------------------

Repository Objects can be exported to XML file

-----------------------------------------------------------------------------------------------------------------------------------------

Re-cycle is not property in sequence generator

-----------------------------------------------------------------------------------------------------------------------------------------

Whether or not session task can be considered to have heterogeneous targets is determined by: The
session task properties alone

-----------------------------------------------------------------------------------------------------------------------------------------

Session has to run Monday to Saturday not on Sunday, how to schedule in informatica? Customized
Report

-----------------------------------------------------------------------------------------------------------------------------------------

Object can be editable when it is Check-out

-----------------------------------------------------------------------------------------------------------------------------------------

Aborting Workflow from workflow monitor is not possible? False

-----------------------------------------------------------------------------------------------------------------------------------------

Same transformation which can be used multiple times is called Reusable transformation

-----------------------------------------------------------------------------------------------------------------------------------------

Where to import target table? Warehouse Designer

-----------------------------------------------------------------------------------------------------------------------------------------

(*not found) Objects are copied in? Workflow designer, Mapping designer, Mapplet Designer, Task
developer

-----------------------------------------------------------------------------------------------------------------------------------------

Can we update target without update strategy in Informatica? YES

-----------------------------------------------------------------------------------------------------------------------------------------

Which is false about Union transformation? You can edit or delete the output group

-----------------------------------------------------------------------------------------------------------------------------------------

Choose Informatica designer tool where mapping can be created? Mapping Designer
-----------------------------------------------------------------------------------------------------------------------------------------

Worklets can be used in workflows? TRUE

-----------------------------------------------------------------------------------------------------------------------------------------

In session log file, which information we can find ? Error encounter, Load Summary, Session Initialization
process

-----------------------------------------------------------------------------------------------------------------------------------------

Choose the ETL tools? Oracle Warehouse Builder, Business Objects, Informatica

-----------------------------------------------------------------------------------------------------------------------------------------

How to select distinct records from Source Qualifier? Choose ‘select distinct’ option

-----------------------------------------------------------------------------------------------------------------------------------------

(*not found) Session can be created in which tool? Mapplet Designer, Workflow Monitor, Mapping
Designer

-----------------------------------------------------------------------------------------------------------------------------------------

Importing and Exporting object is performed in? Mapping Designer, Workflow Manager

-----------------------------------------------------------------------------------------------------------------------------------------

External loader is one of the connection type? TRUE

-----------------------------------------------------------------------------------------------------------------------------------------

To run the session, what is required? Mapping, workflow, task, integration service

-----------------------------------------------------------------------------------------------------------------------------------------

Choose the transformation which merges data from different sources? UNION

-----------------------------------------------------------------------------------------------------------------------------------------

Joiner does not support flat file? False

-----------------------------------------------------------------------------------------------------------------------------------------

How many tasks can be created in Task developer? Multiple

-----------------------------------------------------------------------------------------------------------------------------------------

Lookup can be connected or unconnected? TRUE

-----------------------------------------------------------------------------------------------------------------------------------------

Session performance can be improved by? Partitioning

-----------------------------------------------------------------------------------------------------------------------------------------
What are types of logins in informatica? Native

-----------------------------------------------------------------------------------------------------------------------------------------

Informatica is tool used in data warehousing? TRUE

-----------------------------------------------------------------------------------------------------------------------------------------

We can calculate in aggregator? TRUE

-----------------------------------------------------------------------------------------------------------------------------------------

How many session can run under one workflow? Multiple

-----------------------------------------------------------------------------------------------------------------------------------------

Session can be executed in workflow? Sequentially or concurrently

-----------------------------------------------------------------------------------------------------------------------------------------

Choose the tool where the load progress can be observed? Workflow Monitor

-----------------------------------------------------------------------------------------------------------------------------------------

Mapplet contains? A set of transformation, lets you to reuse transformation logic in multiple mapping

-----------------------------------------------------------------------------------------------------------------------------------------

Which guidelines are needful to optimize the performance of Aggregator transformation?

Use sorted input to decrease the use of aggregated cache, limit connected i/o or output ports, Filter
before aggregating

-----------------------------------------------------------------------------------------------------------------------------------------

Where do you create Repository Service? Admin Console

-----------------------------------------------------------------------------------------------------------------------------------------

Choose the workflow manager tools? Task developer, Workflow Designer

-----------------------------------------------------------------------------------------------------------------------------------------

Repository Service manages? Repository Agent Process, Monitors running repository agent, Repository
Connection Request

-----------------------------------------------------------------------------------------------------------------------------------------

Worklets can be used in workflow? TRUE

-----------------------------------------------------------------------------------------------------------------------------------------

How many types of transformation are available? 2

-----------------------------------------------------------------------------------------------------------------------------------------
Which situation would always cause a mapping to be invalid? Two ports with different data types
connected together

-----------------------------------------------------------------------------------------------------------------------------------------

For Flat file source, relational connection is required? False

-----------------------------------------------------------------------------------------------------------------------------------------

To monitor the run, what should be configure in workflow monitor? Tasks

-----------------------------------------------------------------------------------------------------------------------------------------

You can perform calculation in lookup? True

1. It is possible to take previous version’s code in informatica
a. true
b. false

1. The source qualifier transformation represents the rows that the integration service reads when it runs
a session true or false
a. True

2. What is the use of variable port in expression transformation?

a. to improve performance

b. to reduce time

c. to parameterize value in mapping

d. to store intermediate result.

3. If the datatypes in the source definition and source qualifier transformation do not match
a. the designer marks the mapping invalid when you save it, but failed the session
b. the designer marks the mapping invalid when you save it.
c. the designer marks the mapping invalid when you save it, but failed the workflow in which the
mapping session is present
d. the designer marks the mapping valid when you save it, as we can change datatype manually in SQ.

3. Transformations developed in transformation developer are reusable

1) True

2) False

4. The update strategy expression uses the IIF or DECODE function from the transformation language to
test each row to see if it meets the particular session
a. true
b. false

4. Metadata managed by

a) Integration service

b) Repository service

c) Repository service Admin Control

d) Repository Manager

5. Identify the new features of Informatica 9

a) Single admin console for data quality

b) Informatica analyst is a new tool available

c) Folder creation can be performed from admin

d) None of above

5. The workflow runs successfully in a batch but the session in a workflow fails. What should we do to
make sure workflow also fails in such cases
a. Fail workflow if this task fails
b. Fail parent if this session fails
c. Fail parent if this task does not run
d. Fail workflow if this session fails
e. Fail parent if this task fails

6. Does power center permit us to edit target definition in mapping designer?

a) Yes

b) No

c) Yes but should be done when transformation is unconnected

d) Yes but should be done when transformation is unconnected

e) Yes, only if target definition is reusable

6. Union transformation merges data from multiple sources similar to the UNION ALL SQL statement to
combine the results from two or more SQL statements
a. true
[Link]

7. Choose the server component

a) Repository Service

b) Repository manager

c) Respository service Admin Console

d) Designer
7. In workflow monitor you can view details about a workflow or task in
a. Gantt Chart View
b. task view
c. Line Chart view
d. Bar Chart view
e. None of the option

8. 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
a. true
b. false

8. You are working with very complex mapping which have many transformations. You find very difficult
to identify the source of one of the target point, what is the best way to identify the source

a) Change the target port name and propagate

b) Manually change the name of ports

c) Select the port in target and use the options

d) Use the data lineage feature

f) None

9. Unconnected lookup Transformation support user defined default values

a) True

b) False

10. Power center permits to copy a mapping in a repository into the different repository
a. true
[Link]

11. New version of Informatica 8 compared to 7 :

Unicode compliance

Data profiling

Data steward

Informatica analyst
12. By enabling the enhanced security option, the following permissions are provided

a) Read/Write

b) Append

c) Execute

d) Overwrite

e) Override

12. Consider two sessions are connected in series and you want to execute or let the workflow run the
second session only after the first session completes. What process will you opt for-

a) Two session can’t be run in a workflow

b) Click the link task between sessions

c) Session in a workflow runs only in pmcmd

d) None of these

13. Choose the ETL Tools

1) Informatica

2) Oracle Warehouse Builder

3) Transform on Demand

4) Business Objects

15. Choose the ETL Tools

1) Informatica

2) Oracle Warehouse Builder

3) Transform on Demand

4) Business Objects

Q16) Reusable Transformation is created in

1) Mapping Designer

2) Mapplet Designer
3) Transformation Developer

4) Source Analyzer

18. To filter rows containing null values or spaces in filter transformation we can use __________
function to test the values of port

a) ISNULL

b) IS_SPACES

c) ISNULL AND IS_SPACES

d) NONE

18. Sessions can be executed in workflow

a) Only sequentially

b) Only concurrently

c) Sequentially or concurrently

19. Repository objects can be exported to

a) XML

b) CSV

c) HTML

d) TEXT

19. Suppose we have a source qualifier transformation that populates two target tables . How do you
ensure Target2 is loaded after Target1 .

a) Use constraint based load ordering in session properties

b) Use constraint based load ordering in Mapping parameters

c) Use constraint based load ordering in command properties

d) Use constraint based load ordering in workflow properties

e) It is not possible to load multiple target

20) Administrators and public groups cannot be edited or removed

a) True

b) False

21) What happens if in the source filter property of SQ transformation we include keyword where say

where CUSTOMERS.CUSTOMER_ID = 500;

a) All id greater than 500 are retrieved

b) all id less than 500 are retrieved
c) There is no source filter option in SQ transformation
d) The integration service fails the session
e) none

22) Unlike router and filter transformation, union transformation does allows removal of duplicate rows

a) True

b) False

23) Where do you create groups and users?

a) Repository manager

b) Admin console

c) Mapping designer

d) Repository server

24) Mapping cannot be copied

a) True

b) False

(Deducted) 25) Which all transformation support user defined functions?

a) Any transformation that supports power center expression

b) Expression transformation only

c) Expression and aggregator transformation

d) Custom and expression transformation

e) Expression, aggregator and custom transformation

26) Run a stored procedure every time a row passes through the stored procedure transformation

a) Connected mode

b) Unconnected mode

c) Connected and unconnected mode

d) None

27) Which of these groups are router transformation supported groups

a) User defined group

b) Dynamic group

c) Variable group

d) Static group

e) Custom group

28) Repository objects can be exported to

a) XML

b) CSV

c) HTML

d) Text

29) The user is defaultly assigned to the public group by repository manager

a) true

b) false

30) A domain can have single node

a) true

b) false

31) The stored procedure transformation sends and receives input and output parameters in an
expression using

a) ports
b) variables

c) a & b only

d) by entering a value

Q31)

if your target consists key constraints and indexes that will slow the loading of data and the load type is
est to bulk, what will you do ?

1) Trace level should be verbose Init

2) Drop indexes before Load

3) Drop constraint before load

4) drop table and re-create

5) Trace level should be verbose

32) Importing and exporting of objects is performed in

a) Mapping designer

b) Workflow manager

c) Repository manager

d) Workflow monitor

33) Choose the transformation which is used to generate primary keys

a) Transaction Control
b) Sequence generator

c) Update strategy

d) Sorter

34) What privileges user will get if user is already added in group

a) User will get all the group privileges

b) We have to assign separate privileges to user

c) We have to give permissions to group and user

d) None

35. Choose the transformation functionalities-

a) Generate , modify or pass data

b) Represent the operation perform on data

c) Edit source to target mappings

d) Stores metadata information in the repository

35. How many sessions can run under one workflow

a) one

b)two, one at a time

c) multiple

d)None

36. Where we apply license to services

a) Repository service

b) Application server

c) Integration service

d) Admin console

36. New features of informatica version 9 compared for

a) Informatica analyst

b) Data steward

c) Push Down

d) User Defined Function

37. Which type of source is used in informatica ?

a) Flat
b) Xml

c) Cobol

d) Wsdl

e) All of the above

38) If lookup table is not changed in between sessions then which cache is better to use

a) Static

b) Index

c) Dynamic

d) Persistent

e) Cached

38) Same transformation which can be used multiple times is called

a) Reusable transformation

b) Reusable mapping

c) Reusable session

d) None

39) Where we apply license to the services

a) Repository service

b) Application server

c) Integration service

d) Admin console

40) Identify the correct SQL statement generated by lookup transformation by default

We cannot generate SQL statements in look up

40. Choose the object that cannot be used in mapplet-

a) Normaliser

b) Joiner

c) Target
d) Union

41. The aim of the ETL process is to identify the erroneous data and fix them .State true or False-

a) True

b) False

42. If you declare the mapping parameters and variables in a mapping, you can reuse the mapping by
altering the parameter and variable values of the mapping in the session-

a)True

b)false

42. Power center repository is a collection of data base tables containing meta data

TRUE

43) Importing and exporting of objects is performed in

a) mapping designer

b) workflow manager

c) Repository manager

d) Workflow manager

Q43) How many tasks can be created in task developer

a. only one
b. two
c. multiple
d. none

Q45) How to access the flat files in session

a. through relational connection

b. through the path
c. through the queue connection
d. none
46. Which type of target can be used in informatica-

a) Flat file

b) Xml

c) Relational

d) Wsdl

46. To run the workflow :

integration service should be available,

sessions should be valid,

workflow should be valid

47) Which type of targets are used in informatica

a) Flat file

b) XML

c) Relational

d) WSDl (Its WSDL)

Q.47) chose the resuable task

a. timer

b. event raise

c. event wait

d. email.

47. Identify the transformation which cannot be used upstream from a union transformation

Seq. generator

update strategy

expression

filter

lookup
Q48) The process of resolving inconsistencies and fixing the anomalies in source data typically as the
part of the ETL process

a. Transformation
b. Cleansing
c. Target system
d. Transportation

48) Lookup condition is nothing but a join condition. What type of join is it by default

a. Left outer

b. Right outer

c. Self

d. Inner

e. Full

Q49) Power Center repository is a collection of database tables containing meta data

a. True
b. False

Q50) Sessions are created in

a. workflow monitor
b. mapping designer
c. mapplet desingner
d. none of the above

(Deducted) 50) Choose the informatica designer tool which stores metadata information in repository

a. Source analyzer

b. Warehouse designer

c. mapping designer

d. mapplet designer

51) When you connect transformations to router transformation in a mapping which of the following
statements are true
a) You can connect one group to multiple transformations or targets

b) You can connect one output port in a group to multiple transformations or targets

c) You can connect multiple output port in a group to multiple transformations or targets

d) You can connect more than one group to one target or a single input group transformation

(Not sure) e) You can connect more than one group to a multiple input group transformation except for
joiner transformation, when you connect each output group to a different input group

51. The process of resolving inconsistencies and fixing the anomalies in source data typically as part of
the ETL process

Transformation

Cleansing

Target system

Transportation

52. In filter transformation if the filter condition evaluates to NULL, the row is treated as FALSE

Q56) Identify the correct syntax for oracle source in SQ SQL override

a. to_date(‘$$SessStartTime’,’mm/dd/yyyy hh24:m/ss’)
b. options are not clear

53) What is the scope of user defined function ?

1)The mapping in which the function is defined

2) PowerCentre Domain in which the function is defined

3) Every folder available in the repository

4) the Folder in which the function is defined

5) the workflow in which the session of the mapping is mapped

54. Workflow can run without any issues, even if integration service is not available FALSE

56. What if the incoming data is greater than the amount of sorter data cache

a) Sorter will store the data temporarily in any available transformation cache

b) Sorter will store the data temporarily in work directory

c) The sessions task

d) Sorter stores data upon the maximum cache size

e) None

57. For flat file source relational connection is required: FALSE

58. Each type of transformation has a same set of options that you can configure FALSE

59. In filter transformation if the filter condition evaluates to NULL, the row is treated as FALSE

59. What privileges user will get if user is already added in the group?
a. User will get all the group privileges.
b. We have to assign separate privileges to user
c. we have to give permissions to group and user
d. None of the above

60. Choose the designer tools.

a. warehouse designer
b. Transformation developer
c. Task Developer
d. Source Analyzer.
e. None of the above
1.Port_1:string,input port;Port_2:string,input Port;Port_3:string,output [Link] that is associated
with port3 and the string END STRING is not a variable.

ANS: port1||port2||'ENDSTRING'

2. Source-target information is stored in

ANS: Repository Database.

3. where does Informatica stores data until it completes aggregate calculation.

ANS: Database

[Link] Join that a source qualifier provides.

ANS:Inner Eqi Join.

[Link] from one transformation to any other transformation using debugger can be done using

ANS: Break Point.

[Link] Manager is not used for

ANS:[Link] Session
[Link] Mapping

[Link] use connected look up

ANS:

8. Row will not have Sql written for it

ANS: DD_Reject

9. Number of threads depend on _____________ information pipeline

ANS:Partition

10. Where will you set the type of update for in update strategy Transformation.

ANS: Session or Mapping

[Link] A Look up table is not changed in between session, which cache is better to use?

ANS: Persistant

12. Forms Appropriate for dataware housing

ANS:OLAP

[Link] of SQL override in SQL qualifier.

ANS:Joining 2 or more homogenous sources, filtering unneccessary data, Change column order source.

[Link] support user defined return values.

ANS:Informix.

[Link] that load manager doesnot perform.

ANS:Locking and Reading session.

[Link] a look up on a small set of unchanging values which functions will degrade session performance.

ANS: Not Null, Is Null, IIF.

[Link] many bytes are required for each character.

ANS:1 BYTE

18.____________ will aggregator transformation.

ANS: Incremantal aggregator transformation, sorted input, group by columns.

[Link] object is target then wat are the dependancies that are displayed when 'view dependanceies'.

ANS: Sources that are dependant on target.

mapping using target.
Shortcut for target.

[Link] options available in repository manager.

ANS: privileges, groups, users.

[Link] transformations in designer using

ANS: Mapping designer

Mapplet Designer
Transformation developer

[Link] we use normaliser transformation with COBOL sources often stored in

ANS: Denormaliser form

[Link] included in Mapplet.

ANS: Normaliser,XML sources, target definitions.

[Link] source option for update startegy transformation

ANS: Data Driven

[Link] Types

ANS: 3

[Link] is cache created.

ANS: Cache directory.

[Link] sources with respect to file sources

ANS:Fixed width file is supported, delimited file is supported , one source act as place holder for multiple
sources.

[Link] of variable port.

ANS: It is used to store intermediate result.

[Link] Employee table, we have to get only the emp id = 10. where will we place look up.

ANS:Near the Source.

[Link] can a task get fail in a workflow

Ans: fail me , fail parent task if current task fails.