What is Datadriven?
Answers were Sorted based on User's Feedback
Answer / swetha
The informatica server follows instructions coded into
update strategy transformations with in the session maping
determine how to flag records for insert,update, delete or
reject
If you do not choose data driven option setting, the
informatica server ignores all update strategy
transformations in the mapping.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / shashiall
select Data Driven in Update Strategy Transformations.
if not ...then the informatica sever wil not consider
it and will ignore this.
Data driven is not Used when using the BULK load.
(may b it is correct ..plz try this)
| Is This Answer Correct ? | 5 Yes | 1 No |
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
Explain the mapping variable usage example in informatica
What are the different tools in workflow manager?
Is it possible to use a client with different version than that of its Informatica server?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
how to improve performence by using sorted input in aggrigator t/r.
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
What do you understand by SOA of Informatica?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain the shared cache and re-cache?