Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
68 Cards in this Set
- Front
- Back
In Designer you can search... |
Fields and Tables |
|
In Workflow Manager you can search... |
Tasks and Sessions and Links and Variables |
|
In Designer you can import these sources: |
Database, File, COBOL, XML, PeopleSoft, WSDL, Web Service Provider, PowerExchange, and Salesforce.com |
|
In Designer you can import these targets: |
Database, File, XML, TIBCO, WSDL, Web Service Provider, PowerExchange, and Salesforce.com |
|
What logs can you see in Workflow Monitor? |
Session and Workflow |
|
What views can you use in Workflow Monitor? |
Task and Gantt |
|
Can Workflow Monitor filter by task? |
Yes |
|
Is Source Qualifier Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is an Aggregator transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is a Custom transformation Active/Passive Connected/Unconnected? |
Active/Passive/Connected |
|
Is a Data Masking transformation Active/Passive Connected/Unconnected? |
Passive/Connected |
|
Is an Expression transformation Active/Passive Connected/Unconnected? |
Passive/Connected |
|
Is an External Procedure transformation Active/Passive Connected/Unconnected? |
Passive/Connected/Unconnected |
|
Is a Filter transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is a HTTP transformation Active/Passive Connected/Unconnected? |
Passive/Connected |
|
Is an Input transformation Active/Passive Connected/Unconnected? |
Passive/Connected |
|
Is a Java transformation Active/Passive Connected/Unconnected? |
Active/Passive/Connected |
|
Is a Joiner transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is a Lookup transformation Active/Passive Connected/Unconnected? |
Active/Passive/Connected/Unconnected |
|
Is a Normalizer transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is a Output transformation Active/Passive Connected/Unconnected? |
Passive/Connected |
|
Is a Rank transformation Active/Passive Connected/Unconnected? |
Passive/Connected |
|
Is a Router transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is a Sequence Generator transformation Active/Passive Connected/Unconnected? |
Passive/Connected |
|
Is a Sorter transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is an Application Source Qualifier transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is a SQL transformation Active/Passive Connected/Unconnected? |
Active/Passive/Connected |
|
Is a Stored Procedure transformation Active/Passive Connected/Unconnected? |
Passive/Connected/Unconnected |
|
Is a Transaction Control transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is an Union transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is an Unstructured Data transformation Active/Passive Connected/Unconnected? |
Active/Passive/Connected |
|
Is a Update Strategy transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is a XML Generator transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is a XML Parser transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
Is a XML Source Qualifier transformation Active/Passive Connected/Unconnected? |
Active/Connected |
|
What are the source definition options for a Source Qualifier? |
Relational and Flat File |
|
Can a Source Qualifier join tables? |
Only if they are from the same source database, have a primary key-foreign key relationship, and matching datatypes |
|
What is a Source Qualifier's join default? |
Inner |
|
What type of SQL statement does a source filter create and what type of file can't use a source filter? |
WHERE statement, Flat Files can't (they need a filter transformation) |
|
Where can you call a distinct? |
Source Qualifier |
|
Order of Expression Ports processed. |
I,V,O |
|
Aggregate Functions |
AVG, COUNT, FIRST, LAST, MAX, MEDIAN, MIN, PERCENTILE, STDDEV, SUM, VARIANCE |
|
Can an Aggregator have multiple nested functions? |
Yes |
|
Can an Aggregator have both single- level and nested functions? |
No |
|
How does an Aggregator handle Group By? |
It outputs the last row of each group unless otherwise specified. |
|
How does Aggregator treat Nulls? |
Null as default or as zero |
|
When Aggregator sorted option is selected what can't you use? |
Can't use nested or incremental aggregator functions |
|
How is Aggregator transformation logic applied? |
Transaction- All rows in a transaction or All Input- all incoming data |
|
Where can you Lookup Data? |
Flat file, Relational table, View, Synonym |
|
What sources can you use in Lookups? |
Flat files, Relational Table, and Source Qualifiers |
|
Can you perform a calculation in Lookups? |
Yes |
|
What is the difference between connected and unconnected Lookups? |
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. |
|
What is the difference between static and dynamic cache? |
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. |
|
Once you select a Lookup to return multiple values can it be reverted? |
No |
|
What is the difference between a cached and uncached Lookup? |
Cached- stores the Lookup table to lookup from for each output.
Uncached- Searches the Lookup table for each output port. |
|
How do you improve a Lookup's performance, by cached type? |
Cached- Index columns in ORDER BY
Uncached- Index columns in lookup condition |
|
If you enter an ORDER BY override on Lookups how do you surppress the auto-generated ORDER BY? |
place two dashes '--' after the ORDER BY override |
|
When entering multiple conditions into Lookup how are they treated? |
as 'AND' statements |
|
Does Lookup match Null values? |
Yes |
|
What opperator(s) can you use on a dynamic Lookup? |
= |
|
How does Lookup handle multiple matches? |
Can configure to return first or last matching record.
If uses a static or uncached returns an error |
|
If you do not change the Lookup table between sessions what type of cacheing can you use? |
Persistent, it saves and reuses caches |
|
What is the default join for a Joiner? |
Inner |
|
What cannot be placed before the Joiner? |
Update Stratagy or Sequence Generator |
|
Which table should be the Master in a Joiner? |
The table with the least rows |
|
What are the differences between Connected and Unconnected Lookup? |
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
|
|
What is the difference between Router and Filter? |
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.
|
|
What are the different lookup cache(s)? |
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 |