what is data driven in update strategy transformation?
- 2 Answers
- 15868 Views
- HCL, PayPal, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / infa_geek
Integration Service follows instructions coded into Update
Strategy and Custom transformations within the session
mapping to determine how to flag rows for insert, delete,
update, or reject.
If the mapping for the session contains an Update Strategy
transformation, this field is marked Data Driven by
default.
If you do not choose Data Driven when a mapping contains an
Update Strategy or Custom transformation, the Workflow
Manager displays a warning.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / srinu
data driven is a set of rules.based upon this rules the
integration service perfoms all operations in update
strategy transformation.
DD_INSERT
DD_UPDATE
DD_REJECT
DD_DELETE
| Is This Answer Correct ? | 6 Yes | 4 No |
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What happens if we dont select data driven option?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
how much memory (size) occupied by a session at runtime
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the types of presistent cache in look up tr.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
When the informatica server marks that a batch is failed?
Insert else update option in which situation we will use
Teradata 
