FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

Informatica INTERVIEW QUESTION & ANSWERS

Data Warehousing
Follow Us
 
TAGS
56. What are the different types of transformations available in Informatica?
 
  • Aggregator
  • Application Source Qualifier
  • Custom
  • Expression
  • External Procedure
  • Filter
  • Input
  • Joiner
  • Lookup
  • Normalizer
  • Output
  • Rank
  • Router
  • Sequence Generator
  • Sorter
  • Source Qualifier
  • Stored Procedure
  • Transaction Control
  • Union
  • Update Strategy
  • XML Generator
  • XML Parser
  • XML Source Qualifier
Your Name Your Email-ID
Your Answer
 
57. What is a transformation language?
  It is a language which is similar to SQL functions so, one can write expressions to modify the data or test the data.
Your Name Your Email-ID
Your Answer
 
58. Is Aggregator a passive/active transformation?
  Active
Your Name Your Email-ID
Your Answer
 
59. What are the constants used in update strategy?
 
  • DD_INSERT
  • DD_UPDATE
  • DD_DELETE
  • DD_REJECT
Your Name Your Email-ID
Your Answer
 
60. What are the benefits of DWH?
 
  • Immediate information delivery
  • Data Integration from across, even outside the organization
  • Future vision of historical trends
  • Tools for looking at data in new ways
  • Enhanced customer service
Your Name Your Email-ID
Your Answer