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
- 26322 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 |
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
What is the scenario which compels informatica server to reject files?
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
what is the function of 'F10' informatica ?
What are the parts of Informatica Server?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
Why we require dwh in particular projects?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
What is difference between a connected look up and unconnected look up?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
How to go to the older version for a mapping?
Teradata 
