1=which of the following type of sources are supported for sorter transformation?
A=relational database & flat files
B= relational database & COBOL files
C= relational database & COBOL files & FLAT FILES
D= relational database ONLY
2=with which of the following the master gateway is associated?
A=Node if you do not have high availability and domain if you do
3=which of the following is related to character sets during the repository configuration?
B=none of the listed options
4=In which of the following tab of Domain in Administration console you can view or modify the user permission?
B=user activity monitoring
5=the integration services holds two different values for a workflow variable what are they?
A=start value and end value
B=current value and end value
C=start value and current value
6=what are the available windows in workflow manager?
A= navigator, workspace, overview
C=navigator, workspace, output, overview
D=navigator, workspace, output
7=which of the following components integration service does not use to move data from source to target?
A=data transformation manager(DTM)process
D= integration service process
8=we can run session task ………….?
B=both concurrently & sequentially
D=one sessin at a time
9=which of the below statement is not true about reusable transformation?
A=when you add a reusable transformation to a mapping you add an actual transformation
B=you can create reusable transformation in transformation developer or mapping developer
C=reusable transformation can be used in multiple mappings
D=the transformation marked as reusable in mapping designer cannot be reversed
10=how can you identify source bottleneck in case of relational source?
A=use a filter transformation
B=all of the listed options
C=use a read test mapping
D=use a database query
11=where can you create workflow task?
A=in task developer
B=in task developer or workflow designer
C= in task developer or workflow designer, or the worklet designer
D= in task developer or workflow designer, or the worklet designer or session wizard
12=what power center does while validating an expression which contain an user defined function?
A=a power center does not validate the user-defined function it just validate expression
B=a power center validates fails with validation error as it contain UDF
D=power center validates both the user-defined function and expression
ANS:A (NOT SURE)
13=you can configure expression syntax for a user-defined function by using the argument, as well as custom function TRUE/FALSE
14=parameter file contain which of the following parameter and variables?
B=1,2,3 & 4
C=1,2 & 3
15=which of the following objects are required to create grid?
A=nodes, workflow & session
C=nodes and domain
16=integration services rolls back transaction under which circumstances?
C=roll back or session failure
D= closed transaction
The Integration Service rolls back transactions in the following circumstances:
Rollback evaluation. The transaction control expression returns a rollback value.
Open transaction. You choose to roll back at the end of file.
Roll back on error. You choose to roll back commit transactions if the Integration Service encounters a non-fatal error.
Roll back on failed commit. If any target connection group in a transaction control unit fails to commit, the Integration Service rolls back all uncommitted data to the last successful commit point.
17=what can be done to improve integration services performation?
A=cache power center metadata for the repository services
B=use native drivers instead of ODBC drivers for the integration services
C=all of the listed options
D=run integration service with high availability
18=which of the following target definition does power center 8 support?
A=relational. Flat file
B= relational. Flat file, XML files
D= relational. Flat file, XML files, COBOL files
19=which of the following setting you can configure while configuring the load balancing for a node?
D=you cannot configure load balancing for node
20=which of the following transformation can be placed b/w the sort origin and the joiner transformation?
21=folder and session name are case sensitive ,mapping parameter and variable name are not case sensitive in parameter file TRUE/FALSE?
Session parameter names are not case sensitive.
Mapping parameter and variable names are not case sensitive TRUE.
22=What are the different states of debugger?
A=initializing running and paused
B=running, paused & aborted
C=starting, running & stopped
D=running, aborted & stopped
23=what happen when you use $target in a stored procedure transformation and the pipeline contain multiple relational target?
A=none of the listed option
B=the DB server uses the database connections you specify for the target
C=the informatica server uses the database connection you specify the target
D= the session fails
24=how many output group can you create in a java transformation?
A=equal to no of output ports
C=equal to no of input ports
25=what type of cache he give performance benefit in Lookup?
B=shared & persistence
C=cache dosent give performance benefit
26=which of the following is true about enabling a high precision data handling?
1=use the decimal datatype with a precision of 16 to 28 in the mapping
2=select enable high precission in the session properties
3=power center will automatically process the high precession data no explicit setting are required
A =1 & 2
27=which of the following statement accurately describes the repository service?
A=each repository service can manage multiple repositories
B=a repository service may be located on two or more domains
C=each repository service can manage only one repository
D=each node must be assigned at least one repository service
28=in which of the following tabs of administration console-you can manage users, monitor user activity & domain activity?
B=you cannot manage user and monitor user activity in administration console
ANS:D NOT SURE
29=workflow schedule can be ……………………?
A=both reusable & non-reusable
30=under which of the following condition you can edit the ports of a target definition in the mapping designer?
A=you cannot change the ports of a target definition in mapping designer under any condition
C=if target definition is reusable
D=if mapping is saved in the repository
31=in joiner transformation to get performation benefits unsorted master source should be ?
3=don’t depend on source size
4=master source should not be cached
32=workflow manager concist of how many tools?
33=a user sets the “treat rows as ” session property as “update” what is the effect of making this selection?
A=all records processed by the session will be treated as update statement on the target table provided that the primary key constraint exists on the corresponding target table definition
B=all records processed by the session will be treated as update statement on the target table
C=the session allowa us the sue of the update strategy transformation provide that one or more update strategy transformation are present in the mapping run by the session
D= the session allowa us the sue of the update strategy transformation provide that one or more update strategy transformation are present in the mapping run by the session & provided that the primary key constraint exists on the corresponding target table definition
34=when you import the COBOL source in the source analyser how does the designer interpret each occurs clause?
A=it creates the different column for each occurs statement in the COLOB file
B=each occurs produce multiple output column for each column in the COBOL data set
C=each occurs produce multiple unique identifier in the mapping pipeline, which may correspond to multiple rows or columns in the COBOL data set
D=it has no effect
35=what you can do to improve session performance?
A=reduce the number of log events generated by the integration service when it run the session
B=set tracing level to verbos data
C=do not set session tracing level to terse
D=all of the listed options
36=the sql always returns one row for each input row in which of the following modes?
37=where can you create a reusable task?
A=in task developer or workflow designer
B=in task developer
C= in task developer or workflow designer or the worklet designer
D= in task developer or workflow designer or the worklet designer or session wizard
38=which of the following statement about DTM is incorrect?
A=retrieve and validate session information from the repository
B=reads the parameter file and expandsworkflow variable
C= verifies connection object permission
D=runs post-sessions stored procedure SQL and shell commands
39=can an active java transformation be converted into passive?
A=need to remove active transformation logic from code first
D=yes, but reverse is not true
40=what are the threads that will be created when you start a session for execution?
A=reader thread and writer thread
B=writer thread and transformation thread
C= reader thread and transformation thread
D=reader, writer and transformation thread
41=what happen in a router transformation when the filter condition for more than one output groups evalutes to true?
A=the router will pass the output data from all the output group where the expression is true
B=the roiuter will generate a transformation error
C=the router will pass the data from first output group where the expression is true
D= the router will pass the data from first output group where the expression is true & where the output port is mapped to another transformation
42=which statement is not true about bulk loading?
A=buk loading improves the performance of a session that insert a target amount of data to target database
B= integration service invokes a database bulk utility and bypass the database log
C=we can enable recovery by bulk loading
D= we can enable recovery by bulk loading when you load to DB2, Sybase, oracle or Microsoft SQL Server
ANS:C & D
43=what system variable can be used within a workflow?
A=workflow start time
B=session start time & workflow start time
C=sys date & workflow start time
D=session start time & sys date
44=what happen when you use $source in a stored procedure transformation and the pipeline contain multiple relational sources joined by a joiner transformation?
B=the session fails
C=integration service uses different database connections
D=DB server uses different database connection
45=which of the following is an optional JAVA transformation property?
B= transformation scope
46=what are the different dispatch mode of load balancing?
B=all listed options
47=what happen when transaction control expression evaluates to a value other then commit. Rollback or continue?
A=the integration service fails the session
B= the integration service rollback the transaction
C= the integration service does not perform any transaction changes
D= the integration service commit the transaction
48=what happen if you edit reusable task instance in workflow designer?
A=you cannot edit the task instance of a reusable task in workflow designer
B=task cannot be reusable, you can only create it inside workflow
C= the original task definition changes
D=the task definition remain unchanged in task developer
49=when 3 session are running in a parallel in a workflow and suspension is enabled what will be the status of the workflow when one of the task fails and other two are still running?
50=under what circumstances is it desirable to alter the datatype in the source qualifier?
A=to alter the way the source definition binds data when it is importing into the mapping
B=when the precession required by the mapping is less then the precesion of the data stored in the table of flat file being read by the source qualifier
C=when the precision required by the mapping is greater than the
D=never. The data type in the source qualifier and the corresponding sources must match
51=aggregator function that cannot be used in incremental aggregator?
A=2 4 & 1
B=1 2 & 3
C=2 4 & 3
D=1 2 & 4
52=by which of the following you access the data in informatica using the ODBC data source?
C=excel & Sybase
53=you might use stored procedures to complete which of the following task?
A=determine if enough space exist in database
B=drop and recreate indexes
C=all of the listed options
D=check the status of the target database
54=which of the following types of objects are visible in repository manager navigation window?
A=mapping, repository user,source & target definition
B=repository, source, target, mapping
C=repository service, integration service, domain, folder
D=source & target definition, integration service, nodes
55=what value of new lookup row specifies that integration service updates the row in the cache?
56=which of the following are true about recovering the workflow?
A=when you recover the workflow, integration service recover the entire workflow and continue running the workflow path
B= when you recover the workflow, integration service recover the failed session and restart the workflow path
C= when you recover the workflow, integration service recover the failed session and continue running the rest of the task in the workflow path
D= you cannot recover a workflow if it fails you need to abort it and restart
57=in which of the following operating modes an integration service can run?
A=normal & safe
B=normal & exclusive
C=enabled & disabled
D=enabled, disabled & exclusive
58=what will be the relationship b/w the code page and the informatica server, source & target?
A=source & target code pages must be subsets of informatica server
B=informatica server and source code page must be subsets of targets
C=informatica server & target code pages must be subsets of source
59=metadata is stored in……………………….?
60=following filter condition used in filter
All the rows having NULL as FIRST_NAME…………………………………..
A=this will give error at run time and the record will be logged in the session log file
B= will bw discarded
C=the condition is invalid
D=will be passed to the next transformation