Why we select the table which has minimum number of records
as Master table in joiner?
Answer Posted / balaswamy
because all rows from the master table are loaded into the cache,so that it will take up the least amount of space in the
cache
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
Can you use flat files in Mapplets.
How might you approve all mappings in the archive all the while?
What are the prerequisite tasks to achieve the session partition?
draw informatica architecture 8.6 ?
What is sq transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is an Integration service in Informatica?
How can we use mapping variables in informatica? Where do we use them?
what are 3 tech challenges/ common issues you face?
How we can create indexes after completing the load process?
Explain the types of transformations?
What do mean by local and global repository?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?