In update strategy target table or flat file which gives
more performance ? why?
- 7 Answers
- 21824 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 |
how to design mapping half of source table records into one target and remaining half into another target
Can you copy the batches?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
can we use cartesian join in informatica
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
What are the data movement modes in informatcia?
What is the difference between SOURCE and TARGET BASED COMMITS?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
how to identify new and old values in source qualifier or any other transformations using informatica
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
what is the gap analysis?
Teradata 
