In update strategy target table or flat file which gives
more performance ? why?
Answer Posted / 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 |
Post New Answer View All Answers
What does role playing dimension mean?
where to store informatica rejected data? How to extract the informatica rejected data?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Write the prerequisite tasks to achieve the session partition?
Which are the different editions of informatica powercenter that are available?
What is decode in static cache?
What is a node in Informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
can u give example for factless fact table
Name the different lookup cache(s)?
What is complex mapping?
What is a snowflake schema?
Why filter transformation is an active one?
What does cheating measurement mean?
Write the unconnected lookup syntax and how to return more than one column.