Interested to Buy Any Domain ? << Click Here >> for more details...
Hi 2 every one. i dont have real time experience, and please
suggest me for following questions.
a) we get the source data from what type of source systems?
b) In banking domain project what are the FACT & DIMENTION
tables please list out them?
c) please write some colomn names in a table?
Please reply for aboue questions?..... Thanks in advance.
- 1 Answers
- 6847 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / kishor baindoor
a) source can be Flat files , Cobol Files , Oracle table etc
b) Fact table will be having main data where as dimention
ttable describes attributes of fact table. primary keys for
ddimentional table will foreign key of fact table. go
through dimentional modelling.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
Where can we find the throughput option in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to improve the performance of a session using sorter transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the advantages of informatica?
How many input parameters can exist in an unconnected lookup?
How can we update a record in the target table without using update strategy?
Define enterprise data warehousing?
Write the program through which the records can be updated?
Explain scd type 3 through mapping.
What is a passive transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
