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
- 26556 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhinav
I guess the question was wrong as you cannot update a flat file as target.
In a Flat file data can only be inserted not updated.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / naga
Flat file is better only for Insert,but if you are using
Update strategy for updating a table then table gives
better performance and FYI a Flatfile cannot be updated
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / sriram
Update strategy can be performed on tables not on Flat files.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nishtha
Can someone pls give correct answer for this question?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nagaraju
flat file is better than relational becoz there is no index concet in flat file
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sanjay
Flate file give better performance bcz Retrival of data
from flat file is fast then relation database
| Is This Answer Correct ? | 2 Yes | 5 No |
Why we require dwh in particular projects?
Explain pushdown optimization and types in informatica
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
tell me the push down optimization
Where is metadata stored?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
what is galaxy repository?
how to calculate the optimum cache size in aggregator transformation?
Teradata 
