A quiz created by Swapnil and Ajay for practice of Informatica
Act as a 'where' condition
Can't passes multiple conditions
Act like 'Case' in pl/sql
If one record does not match condition, the record is blocked
No
Yes
Semi-additive
Additive
Confirm fact
Not additive
Confirmed dimension
Rapidly changing dimension
Junk dimension
Degenerated dimension
A code page contains encoding to specify characters in a set of one or more languages
A code page contains decoding to specify characters in a set of one or more languages
In this way application stores, receives, and sends character data.
None of these
Combination of reusable transformation.
Combination of reusable mapping
Set of transformations and it allows us to reuse
None of these
It can be re-used across repositories
I can only be used in mapplet.
It can use in multiple mapping only once
It can use in multiple mapping multiple times
Dd_reject
4
2
Dd_delete
Yes
No
Choose 'non duplicate' option
Choose 'select distinct' option
Choose 'Select non duplicate'
Standalone Repository
Local Repository
User Defined
Versioned Repository
Manual Repository
False
True
Lookup
Store Procedure
Expression
None of these
Aggregator
Lookup
Filter
Expression
Sequence generator
Normalizer
Sql
Store Procedure
Flat file
Relational table
View
Synonyms
All of the above
3
2
1
0
Source qualifier
Joiner
Look up
Source qualifier
Joiner
Look up
Target load order is first the data is load in dimension table and then fact table.
Target load order is first the data is load in fact table and then dimensional table.
Load the data from different target at same time.
Terse
Verbose
Initialization
Verbose initialization
Terse initialization
Session log
Workflow log
Error log
Bad files
Cache files
Yes
No
0
1
2
3
Lookup
Union
Joiner
Sql
Wait!
Here's an interesting quiz for you.