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 |
Is it possible to update the target table with PK?
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
why we need informatica
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Mention few advantages of router transformation over filter transformation.
Separate from a database, an information bazaar, and an information stockroom?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
Without using Lookup & Sequence Generator, How to generate Sequence?
Define mapplet?
Where do we use mapping variables in informatica?