PowerCenter 7 Mapping Design

PowerCenter 7 Mapping Design

QUESTIONS
Specify which designer option cannot be set locally (differently for each client machine)

A. Whether to display column names or business names for all SQ
B. whether to import primary keys when importing a target definition
C. whether to import data type lengths and precisions for SQ
D. whether to display targets grouped by database in the navigator window
Answer: B




QUESTIONS
What types of transformation ports are supported?

A. Input,output,variable
B. input,output,input/output,variable
C. input,output,variable,aggregate
D. input,output,input/output,variable,parameter
Answer: B




QUESTIONS
Which tasks can be performed on a port level(using one specific port)?

A. Enter expressions, define port variables, override default values
B. Enter expressions, define port, and mapping variables, override default values
C. Define local and mapping variables, define parameters, override default values
D. Enter expressions, define port and mapping variables, define parameters
Anserw: A




QUESTIONS
What types of targets are supported in a mapping?

A. Relational
B. Relational and XML
C. Relationsal,XML and flat file
D. Relational,XML, flat file and COBOL
Answer: C




QUESTIONS
Under what circumtances a target definition be edited fromt he mapping desinger, within
the mapping where the target definition is being used?
Answer: Never




QUESTIONS
Whether or not a session task can be considered to have heterogenous targets is determined by

A. The mapping properties alone
B. The session task properties alone
C. Either the mapping properties or the session task properties
D. Either the mapping properties or the workflow properties
Answer: B
QUESITONS
A transformation has the following ports:

Port_1:decimal,input port
Port_2:decimal,inpur 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? Assume it is
associated with Port_4

A. iif(Port_1>5,Port_2*10,Port*15)
B. iif(Port_1>5,Port*10)
C. iif(Port_5>7,Port_5*10,Port_5*15)
D. iif(Port_3>8,Port_3*10,Port_3*15)
Answer: C




QUESTIONS
A transformation has the following ports:

Port_1:String,Input port
Port_2:String,Input port
Port_3:String,Output port

Which of the following expressions shown below would be valid?
Assume that it is associated that Port_3 and that the string
ENDSTRING is not a parameter or mapping variable

A. Port_1 + Port_2 + 'ENDSTRING'
B. Port_1 || Port_2 || "ENDSTRING"
C. Port_1 || Port_2 || ENDSTRING
D. Concat(Port_1,Concat(Port_2,"ENDSTRING"))
Answer: D




QUESITONS
A developer wishes to connect two ports that have different data types, is it allowed?

A. Yes, always
B. Yes, provided tht the data types are compatible. The informatica server
will automatically convert original type to match the destination type
C. Yes, provided that the data types are compatible and the developer
writes a valid conversion function to convert the original type to match the destination type
D. No
Answer: B




QUESIONS
Which situation would always cause a mapping to be invalid?

A. A target definition with no data flowing into it
B. Two ports with different data types connected together
C. Two active transformations connected to the same transaformation
D. A sQ with port names that do not match a field name in the corresponding cource definition
Answer: C




QUESITONS
For a row where the value of the port last_name is equal to the string 'Damato' what would be the
return value os the expression Ltrim(last_name,'A')?

A. Dmato
B. Dmto
C. amato
D. Damato
Answer: D




QUESTIONS
The following are valid Informatica test funstions:

A. isnull,is_date,is_number,is_spaces
B. isnotnull,isdate,ishere
C. is null,isanumber,isadte
D. no_doubt,is_live
Answer: A
QUESTIONS
Can a port in an Expression transformation be given the name DISTINCT?

A. Yes
B. No, because DISTINCT is an ANSI sql reserved word
C. No, because DISTINCT is an Informatica expression reserved word
D. No, because DISTINCT is both an ANSI SQL and an Iformatica
expression reserved word
Answer: A




QUESTIONS
A user finds that she is unable to generate default query in SQ. What is the
possible reason for that?
Answer: The SQ does not have one ro more ports connected to another transformation
or target in the mapping




QUESTIONS
Under what circumstances should a user override the default source qualifier join?

A. The datatypes of the columns used in the join condition do not match
B. The source qualifier is being used to join two tables located on different database servers
C. The Source qualifier is being used to join two or more flat files
D. The order of source qualifier ports has been changed since the mapping was first changed
Answer: A




QUESTIONS
What type od data source(s) can be read with the source qualifier transfromation?

A. Relational databases
B. Relational databases and flat files
C. Relational database, flat files and cobol
D. Relational databases, flat files, cobol and certified ERP sources such a peoplesoft and SAP/R3
Answer: B




QUESTIONS
Can a source qualifier be used to perform an outer join when joining 2 database tables?

A. Yes, but it requires that the user modify the join SQL by hand
B. Yes, but it requires that the user select left ot right outer join as the source qualifier join type property
C. No, because this may produce null values in the ports and the cource qualifier does not support default values
D. No this function is not supported by the source qualifier - a joiner transformation would need to be used
Answer: A




QUESTIONS
What type of expressions can be used in an Aggregator transformation output port?

A. Aggregate and non aggregate expressions, provided thay are not used togethe rin a single port
B. Aggregate and non aggregate expressions together in the same output port
C. Aggregate, non aggregate and conditional expressions together in the same output port
D. Aggregate only
Answer: C
QUESTIONS
What type of expressions can be used in an Aggregator transformation variable port?

A. Aggregate or non Aggregate expressions, provided they are not used together in a single variable port
B. Aggregate and no aggregate expressions together in the same variable port
C. Aggregate, non aggragate and conditional expressions, together in the same variable port, provided that the variable port is also made a group by port
D. Non aggregate and conditional expressions only
Answer: D




QUESTIONS
The aggreagte cache always consists of

A. As index and data cache in RAM and an index and data file on the local disk
B. An index and data cache in RAM, and an index and data cache on the local disk if the RAM caches cannot
contain all of the intermediate results in the data set
C. An index and data cache in RAM, and an index and data dile on the local disk if the file names and directory have been specified as an Aggregator property
D. An index and data cache in RAM, and an index and data file on the local disk if the incremental Aggregation prperty has been set to true when the session runs
Answer: A




QUESTIONS
An aggregator transformation will process 50 million rows per session, and the width of each row is 3 KB. There are
2 group by ports, Month and Customer. Assuming that the data set contains two yars worth of data and there are 500 customers whi are represented for each month on the data set, estimate the required data cache size.

A. 6 MB
B. 12 MB
C. 18 MB
D. 36 MB
Answer: D




QUESTIONS
By default the Aggregator data RAM cache size is 2 MB and the index RAM cache is 1 MB. What would happen if a user ran a session
that required a data RAM cache of 3 MB and the data cache size was left at the default?

A. The session would fail when the aggreagtor begins processing data
B. The session would fail when the data RAM cache exceeds 2 MB
C. The informatica server would automatically expand the data RAM cache to accomodate the additional data
D. The informatica server would automatically page the data to a file on the local disk
Answer: D




QUESTIONS
Select the statement below that is true.

A. The sorter transformation must be used immediately downstream of a source qualifier transformation
B. The sorter transformation must be used immediately downstream of a source qualifier transformation that reads from a relational source
C. The sorter transformation suppoe\rts multiple sort levels, so any sort key can have a secondary sort associated with it
D. The user is allowed to modify the ORDER BY clause generated by the sorter transformation
Answer: C




QUESTIONS
When a sorter transformation is included in a mapping that is run in a workflow, when does the data sort occur?

A.befor ethe workflow runs
B. After the workflow runs
C. Either before or after the workflow runs
D. During the time the Workflow runs (session task run rime)
Answer: D
QUESTIONS
When using the sorter transformation to sort a very large data set additional RAM resources may be required to accomodate the data. Which machine would provide this RAM

A. The informatica server machine
B.The source database server machine
C. The target database server machine
D. The source database server machine when reading from a relational source or the target database server machine when reading from a flat file
Answer: A




QUESTIONS
Why the sorted transformation considered an active transfromation?

A. When the case sensitive property is set to true, rows that do not meet the case criteria in the sort may be discarded
B. When more than sort key is selected nested sorts may result in a single input row being outputted more than one time within multiple sort sequences
C. When the distinc tOutput rows property is set to true duplicate rows are discarded
D. When the sort direction properties are not the same for all sort keys , a single input row may be outputted more than one time
Answer: C




QUESTIONS
What is the difference between the NEXTVAL and the CURRVAL ports of the sequence generator transformation? Assume that they are both connected
to the input ports of another transformation.

A. The informatica server generates a sequence of numbers for the NEXTVAL and Currval is set to the Nextval plus one.
B. The informatica server generates a sequence of numbers for Nextval and Currval is set to Nextval plus one
C. The informatica server generates a sequence of numbers for Curval and Nextval is set to Currval plus one
D. The informatica server generates a sequence of numbers for Currval and Nextval is set to Currval plus the integer value
set dor the Increment By sequence generator property
Answer: A




QUESTIONS
Can the NEXTVAL port of a sequence generator transfromation be connected to the PRIMARY KEY column of two different target table definitions in a mapping?
Assume that the two definitions represent diferent physical tables on the database server.

A. Yes, always
B. Yes, but only if two tables share a primary - foreign key relationship
C. No, because the sequence generator produces unique values and this would result in a unique constraint error
D.No, this is not allowd in the Mapping Desinger
Answer: A
~evaAm



QUESTIONS
What is one disadvantage of using an unconnected lookup transformation?

A. If there is no match in the lookup condition, the informatica server returns a transformation error
B. A reusable unconnected lookup can not have more than one instance in a mapping
C. An unconnected lookup transformation does not support user-defined default values
D. An unconnected lookup transformation does not support a static lookup cache
Answer: C




QUESTIONS
What type of data sources are supported in the Source Type Lookup transformation property?

A. Database
B. Database and flat file
C. Database, flat file and COBOL file
D. Database, flat file, COBOL file, and XML file
Answer: B
QUESTIONS
Select the statement below that most accurately describes how a dynamic lookup cache is designed to function

A. The informatica server compares the target data to the cache data as each row is paased to the target and updates the cache as required
B. The informatica server inserts rows into the cache or updates rows in the cache as it passes rows to the target
C. The informatica server updates the cache as the target table data changes
D. The informatica server inserts, updated or deletes rows oin the cache as it passes rows to target
Answer: B




QUESTIONS
Select the Lookup transformation scenario below which is not supported. Assume that the lookup cache is persistent,
it is shared and named, and there is only one lookup transformation used in the mapping
or mapplet

A. Static cache condition: sales_amt > sales_amt1 unconnected
B. Static cache condition: sales_amt=sales_amt1 unconnected
C. Dynamic cache condition: sales_amt > sales_amt1 connected
D. Dynamic cache condition: sales_amt = sales_amt1 connected
Answer: C




QUESTIONS
It is desired to override the SQL of a non-shared, uncached lookup transformation in order to add a where clause.
Select the action below that must be taken to allow the session to run as designed. Assume that the session has
already been tested prior to the override and it is satisfactory.

A. Cache the lookup
B. Include an Order by clause in the sql the sorts the look up fields in descending order
C. Generate a default query after override SQL has been entered
D. Validate the override SQL on teh actual database table.
Answer: A




QUESTIONS
A developer is attempting to set a Lookup condition and finds that the new condition button is disabled
, making it impossible to set a condition. Assume that it is a connected lookup. What is a possible reason for this?

A. There are no designated lookup ports in the ports tab section
B. There are no designated input ports in the ports tab section
C. There are no ports with compatible data types
D. At least one output port has not been connected to another transformation.
Answer: A




QUESTIONS
It is desired to join together a database table, a flat file and an XML file. All three sources have a single common field called
CUSTOMER_ID. What is the minimum number of joiner transformations that are required to join these sources?

A. One
B. Two
C. Three
D. One if the flat file and the XML file are located in the same directiory
Answer: B




QUESTIONS
A developer is using a Joiner transformation to join two data streams and a full outer join is desired. Select the statement that is true?

A. A joiner transformation may perform a full outer join under all conditions.
B. A joiner transformation may perform full outer join only when one or more sides of the join are from relational database.
C. A joiner transformation may perform full outer join only when all sides of the join originate from relational database
Answer: A
QUESTIONS
Can the Joiner transformation perform a case sensitive string comparison as part of the join condition?

A. Yes, always
B. No
C. Yes when the informatica server is running on the Unix OS, no when it is running on the Windows OS
D. Yes, when the database that is being used for the join supports case sensitive string comparison.
Answer: A




QUESTIONS
A user sets the Treat source rows as session property to Update. What is the effest of making this selection?

A. All records processed by the session will be treated as update statements on the target table
B. All records processed by the session will be treated as update statements on the target table.
provided that a primary key constraint exists on the corresponding target table definition.
C. This selection allows the use of the update strategy transformation provided that one or more update strategy transformations are present in the
mapping run by the session
Answer: B
~evaAm



QUESTIONS
What type of expressions can b used in an Update strategy transformation?

A. Immediate If (IIF)
B. Immediate If (IIF) or DECODE
C. Ummediate If (IIF), DECODE, or IF Then Else
D. Any valid non aggregate expression that is supported by transformational language
Answer: D




QUESTIONS
Specify which statement below describes the behavior of a router transformation that has three groups defined

A. The condition for each group will be evaluted for each row, and the first group that evalutes to a true results will pass that row out
of the transformation through that groups output ports. If no group evalutes to a true result the row will pass out of the transformation
through the default group output ports.

B. The condition for each group will be evaluated for each row, and each group that evaluates to true result will pass
out of the transformation through that group's ports. If no group evalutes to a true result the row will pass out of the transformation
through the default group output ports.

C. The condition for each group will be evaluted for each row, and the first group that evalutes to true result will pass the row out of the
transformation through that group's output ports . If no group evalutes to true result the row will pass out of the transformation through the
default group output ports only if those ports are connected to another transformation.

D. The condition for each group will be evaluted for each row, and each group that evalutes to true result will pass the row out of the transformation through
that group's output ports. If no group evalutes to true result, the row will pass out of the transformation through the default
group output ports only if those ports are connected to another transformation.
Answer: D




QUESTIONS
A filter transformation contains the follwoing condition:
ITEM_COST>100.00. The value for ITEM_COST for a specific row is 35. What will happen to that row?

A. It is dropped from the mapping flow
B. It is dropped from the mapping flow and written to the reject file
C. It is dropped from the mapping flow and written to the reject file if the filter property
Forward filtered row is set to true.
D. if the filter property Forward filtered row is set to true, the row is sent to the downstream transformation, if any,
but not written to the target table.
Answer: A




QUESTIONS
A major difference between the router and filetr transformations is that filtered wors can be captured in the Router

A. True
B. False
Answer: A
QUESTIONS
How many homogenous source definitions can be placed in a mapplet?

A. One
B. One for each source qualifier transformation
C. Zero to One if mapplet does not contain an input or ERP source qualifier transformation
D. Unlimited
Answer: D




QUESTIONS
How many output transformations can be placed in a mapplet?

A. One
B. One or more
C. One or more unless there is one target definition in the mapplet, in which case zero output transformation
are permitted
D. Any number
Answer: B
~arvKh



QUESTIONS
Select the statement below that is true.

A. A mapplet that does not contain an input transaformation is always as active mapplet.
B. A mapplet that does bot contain an input transforamation is an active mapplet only if it contains at least one active transformation
C. A passive mapplet can be made into an active mapplet by adding one or more joiner transformations to the mapplet.
D. A passive mapplet can be made into active mapplet by adding one or more lookup transformation to the mapplet.
Answer: A

QUESTIONS
will the update transformation used before the union transformamtion
Answer: no