tell me some dimension tables names in banking domain
informatica project(dont tell like depends on project, tell
me names of dimension and fact table names in your project)?
Answer Posted / im
Fact Tables:
1)Bank
2) Advanced
Dimension Tables:
1)Customer
2)Account
3)Transation Dirty Dimension
4)Time
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
What is sq transformation?
what is $$$$?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
In how many ways we can create ports?
Enlist the various types of transformations.
According to his methodology what all you need before you build a datawarehouse
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
can we override a native sql query within informatica? How do we do it?
Define joiner transformation?
Explain Dataware house architecture .how data flow from intial to end?
If informatica has its scheduler why using third party scheduler?
Why update strategy and union transformations are active?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
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.