What happens if we dont select data driven option?
- 2 Answers
- 7875 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vidyaveda4
if we dos't select the data driven option. at the time of running of the session it just simply ignores the options set in the update strategy transformation.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / gm
Suppose you are using onely one action like
insert or update or delete
then you can use session proerties.
If you are using more than one action. but you are not
selected data driven. The IS services Ignore the update
Strategy Transformation.
Note: Default is "insert option"
but if your are using more than 2 option then default data
driven.
===========================================================
| Is This Answer Correct ? | 2 Yes | 0 No |
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
how can we calculate fact table size?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
What are the types of metadata that stores in repository?
how we load the data from source to staging area
What does refresh system mean, and what are its distinctive choice?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
Teradata 
