Best Informatica MCQ Qustion Answer
Informatica MCQ
1. In transformations the Ports Order of Evaluation is? This question has only one answer.
Top down
- Input, Variables (top down within Variables), Output
- Input, (top down within input), Output, Variables
- Output, Variables, Input
- None of the above
2. The output from an Aggregator transformation without a
Group by will return? This question has only one answer.
- All the records
- error
- 1 record
- No Records
- None of the above
- Normalizier transformation
- Lookup transformation
- XML Source Qualifier transformation
- Target definitions
- All of them
4. We can auto link the ports between different transformations in which of the following ways in the Designer? This question has more than one answer.
- Drag and Drop
- Common Data Type
- Common Name
- Currency unit
- Position
- All of the above
5. Which of the following feature/features are not found in Informatica (all versions of 6 and below)? This question has only one answer.
- Propagate attributes
- Soundex and Metaphone string functions
- Transaction Control
- Union transformation
- Server Grid
- All of the above
6. Business Component folders in the Designer allow logical groupings of which of the following? This question has more than one answer.
- Source
- Mapplet
- Shortcut to a source
- Shortcut to a mapplet
- Target
- Shortcut to a target
- All of the above
7. Which of the following are examples of Active transformation? This question has more than one answer.
- Aggregator
- Expression
- Lookup
- Sequence Generator
- Filter
- Source Qualifier
8. Which of the following are examples of Passive transformation? This question has more than one answer.
- External Procedure
- Update Strategy
- Stored Procedure
- Joiner
- Rank
9. Which of the following statements are false while joining tables in the Source Qualifier using primary foreign key relationships? This question has more than one answer.
- If the source table has more than 1000 records you can decrease the performance by indexing primary-foreign keys
- If the source table has more than 1000 records you can increase the performance by indexing primary-foreign keys
- If the source table has less than 1000 records you can decrease the performance by indexing primary-foreign keys
- If the source table has less than 1000 records you can increase the performance by indexing primary-foreign keys
10. Which of the following are the different levels of tracing in transformations? This question has more than one answer.
- Precise
- Verbose data
- Terse
- Concise
- Normal
