Interested to Buy Any Domain ? << Click Here >> for more details...
In dimension and fact table? which one holds big data?
- 2 Answers
- 6455 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravikumar2614
Fact table having huge data with less colomns..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How can you increase the performance in joiner transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is a dimensional model?
Explain lookup transformation source types in informatica
Tell me about MD5 functions in informatica
what is degenerated dimension?
can we override a native sql query within informatica? Where do we do it?
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.
How many number of sessions can one group in batches?
How can we improve session performance in aggregator transformation?
What are the restrictions of union transformation?
tell me about your project functionality
Parameter and variable differences
How big was your fact table
