|
INTERVIEW QUESTIONS
DATA WAREHOUSING
ETL
DETAILS
Question: What is a mapping, session, worklet, workflow, mapplet?
Answer: A mapping represents dataflow from sources to targets. A mapplet creates or configures a set of transformations.
A workflow is a set of instruction sthat tell the Informatica server how to execute the tasks.
A worklet is an object that represents a set of tasks.
A session is a set of instructions that describe how and when to move data from sources to targets.
Submited By Francis C ( xxchen74 @ hotmail . com )
|
|
|
Category |
ETL Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 8325 users |
Added on |
12/8/2009 |
Views |
77172 |
Rate it! |
|
|
Question:
What is a mapping, session, worklet, workflow, mapplet?
Answer:
A mapping represents dataflow from sources to targets. A mapplet creates or configures a set of transformations.
A workflow is a set of instruction sthat tell the Informatica server how to execute the tasks.
A worklet is an object that represents a set of tasks.
A session is a set of instructions that describe how and when to move data from sources to targets.
Submited By Francis C ( xxchen74 @ hotmail . com ) 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 |
|
How can we use mapping variables in Informatica? Where do we use them?
|
View Answer
|
|
What are parameter files ? Where do we use them?
|
View Answer
|
|
Can we override a native sql query within Informatica? Where do we do it? How do we do it?
|
View Answer
|
|
Can we use procedural logic inside Infromatica? If yes how , if now how can we use external procedural logic in informatica?
|
View Answer
|
|
Do we need an ETL tool? When do we go for the tools in the market?
|
View Answer
|
|
How do we extract SAP data Using Informatica? What is ABAP? What are IDOCS?
|
View Answer
|
|
How to determine what records to extract?
|
View Answer
|
|
What is Full load & Incremental or Refresh load?
|
View Answer
|
|
Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)
|
View Answer
|
|
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
|
View Answer
|
|
What is partitioning? What are the types of partitioning?
|
View Answer
|
|
When do we Analyze the tables? How do we do it?
|
View Answer
|
|
Compare ETL & Manual development?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All ETL Interview Questions & Answers - Exam Mode /
Learning Mode
|