In update strategy target table or flat file which gives
more performance ? why?
Answer Posted / 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 |
Post New Answer View All Answers
What is Session and Batches?
Can we change Dynamic to Static or Persistent cache? If so what happens?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is decode in informatica?
What is the Process to creating lookup transformation in informatica
To import the flat file definition into the designer where should the flat file be placed?
What are the reusable transformations?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
expain about the tune parameters?
how tokens will generate?
What is a sorter transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
explan ur project architecture?
design of staging area?