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
- 26255 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagaraju
flat file is better than relational becoz there is no index concet in flat file
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How we can create indexes after completing the load process?
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 the use of an aggregator cache file?
What is event and what are the tasks related to it?
Briefly define a session task?
What is update strategy transform?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is $$$$?
what is the Default Source Option For Update Strategy Transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Make a note of the quantity vaults made in informatica?
What are the different components of powercenter?
What are the designer tools for creating transformations?
How to load the data from people soft hrm to people soft erm using informatica?
Explain lookup transformation in informatica
