|
INTERVIEW QUESTIONS
DATA WAREHOUSING
INFORMATICA
DETAILS
Question: Describe two levels in which update strategy transformation sets?
Answer: Within a session: When you configure a session, yoYou can instruct the Informatica Server to either treat all records in the same way (for example, treat all records as inserts), or use instructions coded into the session mapping to flag records for different database operations.
Within a mapping: Within a mapping, you use the Update Strategy transformation to flag records for insert, delete, update, or reject.
|
|
|
Category |
Informatica Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8895 users |
Added on |
10/12/2009 |
Views |
76534 |
Rate it! |
|
|
Question:
Describe two levels in which update strategy transformation sets?
Answer:
Within a session: When you configure a session, yoYou can instruct the Informatica Server to either treat all records in the same way (for example, treat all records as inserts), or use instructions coded into the session mapping to flag records for different database operations.
Within a mapping: Within a mapping, you use the Update Strategy transformation to flag records for insert, delete, update, or reject. 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 is the default source option for update stratgey transformation?
|
View Answer
|
|
What is Datadriven?
|
View Answer
|
|
What are the options in the target session of update strategy transsformatioin?
|
View Answer
|
|
What are the types of maping wizards that are to be provided in Informatica?
|
View Answer
|
|
What are the types of maping in Getting Started Wizard?
|
View Answer
|
|
What are the mapings that we use for slowly changing dimension table?
|
View Answer
|
|
What are the different types of Type2 dimension maping?
|
View Answer
|
|
How can you recognise whether or not the newly added rows in the source are gets insert in the target?
|
View Answer
|
|
What are two types of processes that informatica runs the session?
|
View Answer
|
|
What are the new features of the server manager in the informatica 5.0?
|
View Answer
|
|
Can you generate reports in Informatcia?
|
View Answer
|
|
What is metadata reporter?
|
View Answer
|
|
Define maping and sessions?
|
View Answer
|
|
Which tool you use to create and manage sessions and batches and to monitor and stop the informatica server?
|
View Answer
|
|
Why we use partitioning the session in informatica?
|
View Answer
|
|
To achieve the session partition what are the necessary tasks you have to do?
|
View Answer
|
|
How the informatica server increases the session performance through partitioning the source?
|
View Answer
|
|
Why you use repository connectivity?
|
View Answer
|
|
What are the tasks that Loadmanger process will do?
|
View Answer
|
|
What is DTM process?
|
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 Informatica Interview Questions & Answers - Exam Mode /
Learning Mode
|