|
INTERVIEW QUESTIONS
DATA WAREHOUSING
INFORMATICA
DETAILS
Question: What r the unsupported repository objects for a mapplet?
Answer: Source definitions. Definitions of database objects (tables, views, synonyms) or files that provide source data. Target definitions. Definitions of database objects or files that contain the target data. Multi-dimensional metadata. Target definitions that are configured as cubes and dimensions. Mappings. A set of source and target definitions along with transformations containing business logic that you build into the transformation. These are the instructions that the Informatica Server uses to transform and move data. Reusable transformations. Transformations that you can use in multiple mappings. Mapplets. A set of transformations that you can use in multiple mappings. Sessions and workflows. Sessions and workflows store information about how and when the Informatica Server moves data. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data. A session is a type of task that you can put in a workflow. Each session corresponds to a single mapping.
|
|
|
Category |
Informatica Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 9131 users |
Added on |
7/26/2011 |
Views |
68128 |
Rate it! |
|
|
Question:
What r the unsupported repository objects for a mapplet?
Answer:
Source definitions. Definitions of database objects (tables, views, synonyms) or files that provide source data. Target definitions. Definitions of database objects or files that contain the target data. Multi-dimensional metadata. Target definitions that are configured as cubes and dimensions. Mappings. A set of source and target definitions along with transformations containing business logic that you build into the transformation. These are the instructions that the Informatica Server uses to transform and move data. Reusable transformations. Transformations that you can use in multiple mappings. Mapplets. A set of transformations that you can use in multiple mappings. Sessions and workflows. Sessions and workflows store information about how and when the Informatica Server moves data. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data. A session is a type of task that you can put in a workflow. Each session corresponds to a single mapping. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What r the methods for creating reusable transforamtions?
|
View Answer
|
|
What r the reusable transforamtions?
|
View Answer
|
|
What r the active and passive transforamtions?
|
View Answer
|
|
What is the maplet?
|
View Answer
|
|
Which transformation should u need while using the cobol sources as source defintions?
|
View Answer
|
|
How many ways you can update a relational source defintion and what r they?
|
View Answer
|
|
Where should U place the flat file to import the flat file defintion to the designer?
|
View Answer
|
|
To provide support for Mainframes source data,which files r used as a source definitions?
|
View Answer
|
|
What is Data cleansing..?
|
View Answer
|
|
What is Load Manager?
|
View Answer
|
|
How can we partition a session in Informatica?
|
View Answer
|
|
Explain the informatica Architecture in detail
|
View Answer
|
|
How to read rejected data or bad data from bad file and reload it to target?
|
View Answer
|
|
Diff between informatica repositry server & informatica server
|
View Answer
|
|
How do you transfert the data from data warehouse to flatfile?
|
View Answer
|
|
What r the tasks that Loadmanger process will do?
|
View Answer
|
|
How can U create or import flat file definition in to the warehouse designer?
|
View Answer
|
|
What r the connected or unconnected transforamations?
|
View Answer
|
|
What is a time dimension? give an example.
|
View Answer
|
|
Discuss the advantages & Disadvantages of star & snowflake schema?
|
View Answer
|