In update strategy target table or flat file which gives
more performance ? why?
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 |
Explain sessions?
my source is junk data how will u remove that junk data by using unix please any one replay me
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
What are Dimensional table?
what is confirmed dimension?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
what is a time dimension? give an example?
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
What is rank transform?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com