Interested to Buy Any Domain ? << Click Here >> for more details...
In update strategy target table or flat file which gives
more performance ? why?
- 7 Answers
- 26252 Views
- I also Faced
- E-Mail Answers
Answer Posted / naga
Flat file is better only for Insert,but if you are using
Update strategy for updating a table and also we a Flat
file cannot be updated
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are the measure objects?
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?
What are the static cache and dynamic cache in informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is informatica? Why do we need it?
How to improve the performance of a session using sorter transformation?
Tell me about Propagate functions in informatica
How do you handle two sessions in Informatica
what are the deliverables?in your project?
how to load dimension table and fact table. plz tell me the steps.
How to load the data from people soft hrm to people soft erm using informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are junk dimensions?
How an expression transformation differs from aggregator transformation?
What is dimensional table? Explain the different dimensions.
