Informatica Certification

Front 1

In Designer you can search...

Back 1

Fields and Tables

Front 2

In Workflow Manager you can search...

Back 2

Tasks and

Sessions and

Links and

Variables

Front 3

In Designer you can import these sources:

Back 3

Database, File, COBOL, XML, PeopleSoft, WSDL, Web Service Provider, PowerExchange, and Salesforce.com

Front 4

In Designer you can import these targets:

Back 4

Database, File, XML, TIBCO, WSDL, Web Service Provider, PowerExchange, and Salesforce.com

Front 5

What logs can you see in Workflow Monitor?

Back 5

Session and Workflow

Front 6

What views can you use in Workflow Monitor?

Back 6

Task and Gantt

Front 7

Can Workflow Monitor filter by task?

Back 7

Yes

Front 8

Is Source Qualifier Active/Passive Connected/Unconnected?

Back 8

Active/Connected

Front 9

Is an Aggregator transformation Active/Passive Connected/Unconnected?

Back 9

Active/Connected

Front 10

Is a Custom transformation Active/Passive Connected/Unconnected?

Back 10

Active/Passive/Connected

Front 11

Is a Data Masking transformation Active/Passive Connected/Unconnected?

Back 11

Passive/Connected

Front 12

Is an Expression transformation Active/Passive Connected/Unconnected?

Back 12

Passive/Connected

Front 13

Is an External Procedure transformation Active/Passive Connected/Unconnected?

Back 13

Passive/Connected/Unconnected

Front 14

Is a Filter transformation Active/Passive Connected/Unconnected?

Back 14

Active/Connected

Front 15

Is a HTTP transformation Active/Passive Connected/Unconnected?

Back 15

Passive/Connected

Front 16

Is an Input transformation Active/Passive Connected/Unconnected?

Back 16

Passive/Connected

Front 17

Is a Java transformation Active/Passive Connected/Unconnected?

Back 17

Active/Passive/Connected

Front 18

Is a Joiner transformation Active/Passive Connected/Unconnected?

Back 18

Active/Connected

Front 19

Is a Lookup transformation Active/Passive Connected/Unconnected?

Back 19

Active/Passive/Connected/Unconnected

Front 20

Is a Normalizer transformation Active/Passive Connected/Unconnected?

Back 20

Active/Connected

Front 21

Is a Output transformation Active/Passive Connected/Unconnected?

Back 21

Passive/Connected

Front 22

Is a Rank transformation Active/Passive Connected/Unconnected?

Back 22

Passive/Connected

Front 23

Is a Router transformation Active/Passive Connected/Unconnected?

Back 23

Active/Connected

Front 24

Is a Sequence Generator transformation Active/Passive Connected/Unconnected?

Back 24

Passive/Connected

Front 25

Is a Sorter transformation Active/Passive Connected/Unconnected?

Back 25

Active/Connected

Front 26

Is an Application Source Qualifier transformation Active/Passive Connected/Unconnected?

Back 26

Active/Connected

Front 27

Is a SQL transformation Active/Passive Connected/Unconnected?

Back 27

Active/Passive/Connected

Front 28

Is a Stored Procedure transformation Active/Passive Connected/Unconnected?

Back 28

Passive/Connected/Unconnected

Front 29

Is a Transaction Control transformation Active/Passive Connected/Unconnected?

Back 29

Active/Connected

Front 30

Is an Union transformation Active/Passive Connected/Unconnected?

Back 30

Active/Connected

Front 31

Is an Unstructured Data transformation Active/Passive Connected/Unconnected?

Back 31

Active/Passive/Connected

Front 32

Is a Update Strategy transformation Active/Passive Connected/Unconnected?

Back 32

Active/Connected

Front 33

Is a XML Generator transformation Active/Passive Connected/Unconnected?

Back 33

Active/Connected

Front 34

Is a XML Parser transformation Active/Passive Connected/Unconnected?

Back 34

Active/Connected

Front 35

Is a XML Source Qualifier transformation Active/Passive Connected/Unconnected?

Back 35

Active/Connected

Front 36

What are the source definition options for a Source Qualifier?

Back 36

Relational and Flat File

Front 37

Can a Source Qualifier join tables?

Back 37

Only if they are from the same source database, have a primary key-foreign key relationship, and matching datatypes

Front 38

What is a Source Qualifier's join default?

Back 38

Inner

Front 39

What type of SQL statement does a source filter create and what type of file can't use a source filter?

Back 39

WHERE statement, Flat Files can't (they need a filter transformation)

Front 40

Where can you call a distinct?

Back 40

Source Qualifier

Front 41

Order of Expression Ports processed.

Back 41

I,V,O

Front 42

Aggregate Functions

Back 42

AVG, COUNT, FIRST, LAST, MAX, MEDIAN, MIN, PERCENTILE, STDDEV, SUM, VARIANCE

Front 43

Can an Aggregator have multiple nested functions?

Back 43

Yes

Front 44

Can an Aggregator have both single- level and nested functions?

Back 44

No

Front 45

How does an Aggregator handle Group By?

Back 45

It outputs the last row of each group unless otherwise specified.

Front 46

How does Aggregator treat Nulls?

Back 46

Null as default or as zero

Front 47

When Aggregator sorted option is selected what can't you use?

Back 47

Can't use nested or incremental aggregator functions

Front 48

How is Aggregator transformation logic applied?

Back 48

Transaction- All rows in a transaction

or

All Input- all incoming data

Front 49

Where can you Lookup Data?

Back 49

Flat file, Relational table, View, Synonym

Front 50

What sources can you use in Lookups?

Back 50

Flat files, Relational Table, and Source Qualifiers

Front 51

Can you perform a calculation in Lookups?

Back 51

Yes

Front 52

What is the difference between connected and unconnected Lookups?

Back 52

Unconnected- Must be called and can only return one row. Static cache only. Can't define default values.

Connected- Can use dynamic or static cache. Can return multiple columns. Can define default values.

Front 53

What is the difference between static and dynamic cache?

Back 53

Static- Does not update the cache while it processes the transformation. Default Lookup setting.

Dynamic- inserts or updates data in cache and passes data to target.

Front 54

Once you select a Lookup to return multiple values can it be reverted?

Back 54

No

Front 55

What is the difference between a cached and uncached Lookup?

Back 55

Cached- stores the Lookup table to lookup from for each output.

Uncached- Searches the Lookup table for each output port.

Front 56

How do you improve a Lookup's performance, by cached type?

Back 56

Cached- Index columns in ORDER BY

Uncached- Index columns in lookup condition

Front 57

If you enter an ORDER BY override on Lookups how do you surppress the auto-generated ORDER BY?

Back 57

place two dashes '--' after the ORDER BY override

Front 58

When entering multiple conditions into Lookup how are they treated?

Back 58

as 'AND' statements

Front 59

Does Lookup match Null values?

Back 59

Yes

Front 60

What opperator(s) can you use on a dynamic Lookup?

Back 60

=

Front 61

How does Lookup handle multiple matches?

Back 61

Can configure to return first or last matching record.

If uses a static or uncached returns an error

Front 62

If you do not change the Lookup table between sessions what type of cacheing can you use?

Back 62

Persistent, it saves and reuses caches

Front 63

What is the default join for a Joiner?

Back 63

Inner

Front 64

What cannot be placed before the Joiner?

Back 64

Update Stratagy or Sequence Generator

Front 65

Which table should be the Master in a Joiner?

Back 65

The table with the least rows

Front 66

What are the differences between Connected and Unconnected Lookup?

Back 66

Connected Lookup Unconnected Lookup

Connected lookup participates in dataflow and receives input directly from the pipelineUnconnected lookup receives input values from the result of a LKP: expression in another transformation

Connected lookup can use both dynamic and static cacheUnconnected Lookup cache can NOT be dynamic

Connected lookup can return more than one column value ( output port )Unconnected Lookup can return only one column value i.e. output port

Connected lookup caches all lookup columnsUnconnected lookup caches only the lookup output ports in the lookup conditions and the return port

Supports user-defined default values (i.e. value to return when lookup conditions are not satisfied)Does not support user defined default values

Front 67

What is the difference between Router and Filter?

Back 67

RouterFilter

Router transformation divides the incoming records into multiple groups based on some condition. Such groups can be mutually inclusive (Different groups may contain same record)Filter transformation restricts or blocks the incoming record set based on one given condition.

Router transformation itself does not block any record. If a certain record does not match any of the routing conditions, the record is routed to default groupFilter transformation does not have a default group. If one record does not match filter condition, the record is blocked

Router acts like CASE.. WHEN statement in SQL (Or Switch().. Case statement in C)Filter acts like WHERE condition is SQL.

Front 68

What are the different lookup cache(s)?

Back 68

Informatica Lookups can be cached or un-cached (No cache). And Cached lookup can be either static or dynamic. A static cache is one which does not modify the cache once it is built and it remains same during the session run. On the other hand, A dynamic cache is refreshed during the session run by inserting or updating the records in cache based on the incoming source data. By default, Informatica cache is static cache.

A lookup cache can also be divided as persistent or non-persistent based on whether Informatica retains the cache even after the completion of session run or deletes it