Advertise
     Here
Home   Contact     Site Map
Request Information   
(732) 248-1900   1-877-85-eTeam(38326)
About Us Clients Experts Resources Training News Press Releases Success stories Help/FAQ
 
Test My Skills
 
Informatica
Author : Bhaskar Joshi
Name: *  
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
3. Which of the following objects cannot be used in a mapplet (not considering Power Mart 3.5)? This question has more than one answer.
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
11. Shortcuts can be created from which of the following? This question has only one answer.
Source definitions
Reusable transformations
Mapplets
Business components
Target definitions
All of the above
None of the above
12. Pass-through partitioning is created in which of the transformations by default? This question has more than one answer.
Rank
Target instances
Source Qualifier
Rank
Joiner
Normalizer
13. For a filter transformation, which of the following partition would be most ideal? This question has only one answer.
Pass-through
Hash auto key
Round Robin
Key range
None of the above
14. Performance bottlenecks should be generally looked for in which of the following order? This question has only one answer.
Target, Source, Mapping, Session, System
System, Session, Mapping, Source, Target
Source, Target, Session, Mapping, System
Target, System, Mapping, Source, Session
Session, Mapping, System, Target, Source
Mapping, Session, Target, Source, System
15. Which of the following best describes Slowly changing dimension type 2? This question has only one answer.
Stores only the latest data
Stores the whole history
Stores the two of the most recent data
Doesn’t store anything
None of the above
 
eTeam, Inc. provides process and technology subject matter expertise in the areas of Analytics to a large manufacturing company.
eTeam, Inc. provides training in Siebel ePharma to a sales workforce of an international pharmaceutical company.
eTeam, Inc. provides Ascential Datastage and QualityStage expertise to a healthcare provider.
  More news...
"eTeam believes in partnering itself in the whole process of the projects, which gives them an edge over other consulting organizations."
Partial client list...
 Privacy Policy Legal Join our Team  

Copyright © 2005. All rights reservered. CRM and DW ExpertsTM is owned and operated by eTeam Inc.
Site designed and developed by Ravidhu Inc.