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
- 25964 Views
- I also Faced
- E-Mail Answers
Answer Posted / sriram
Update strategy can be performed on tables not on Flat files.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to load dimension table and fact table. plz tell me the steps.
Reusable transformation and shortcut differences
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is data caches/ index caches?
Where are the source flat files kept before running the session?
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.
Explain what are the different versions of informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How many types of sessions are there in informatica.please explain them?
What is a stored procedure transformation?
What are the tasks that source qualifier perform?
Plz can any one say me how to get the informatica certification materials and dumps
What do think which one is the better joiner or look up?
What is the way to execute pl/sql script using informatica mapping?
What is dimensional table?
