Informatica interview questions – page 12

What are the active and passive transforamtions?

What is DTM process?

Which tool you use to create and manage sessions and batches and to monitor and stop the informatica server?

Why we use stored procedure transformation?

While importing the relational source defintion from database, what are the meta data of source you import?

What are the transformations that restricts the partitioning of sessions?

What is the difference between informatics 7x and 8xand what is latest version?

What is worklet and what use of worklet and in which situation we can use it

Can u start a batches with in a batch?

The designer includes a "Find" search tool as part of the standard tool bar. What can it be used to find?

What r the options in the target session of update strategy transsformatioin?

How to read rejected data or bad data from bad file and reload it to target?

How is the union transformation active transformation?

What are two modes of data movement in Informatica Server?

What is mystery dimention?

What are cost based and rule based approaches and the difference

What are the types of metadata that stores in repository?

Whats the diff between Informatica powercenter server, repositoryserver and repository?

In update strategy target table or flat file which gives more performance ? why?

What is the limit to the number of sources and targets you can have in a mapping

What are the basic needs to join two sources in a source qualifier?

Partitioning, Bitmap Indexing (when to use), how will the bitmap indexing will effect the performance

Know the rules associated with transferring and sharing objects between repositories

What r the mapping paramaters and maping variables?

How do you transfert the data from data warehouse to flatfile?

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

How can I get distinct values while mapping in Informatica in insertion?

What is Data Transformation Manager?

What are the new features of the server manager in the informatica 5.0?

Could anyone please tell me what are the steps required for type2 dimension/version data mapping. how can we implement it