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
- 26249 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 |
what is junk dimension
When you move from devel to prod how will you retain a variable
As union transformation gives UNION ALL output, how you will get the UNION output?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
can u any challenge your project?
Why touse stored procedure in ETL Application?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
How can we get multiple output values using an unconnected lookup transformation?
What will be the approach?
where to store informatica rejected data? How to extract the informatica rejected data?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
What is A complex mapping?
Teradata 
