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
- 26294 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to generate sequence numbers without using the sequence generator transformation?
What are the types of data warehouses?
What is meant by incremental aggregation?
What differs when we choose the sorted input for aggregator transformation?
What is status code in informatica?
What are the measure objects?
Explain the different lookup methods used in informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Which files are created during the session rums by informatics server?
Enlist the differences between database and data warehouse.
What is the format of informatica objects in a repository?
Can we create multiple integration service on single repository?
How do you load only null records into target?
