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
- 6857 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer / 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 |
Explain grouped cross tab?
what is unit testing?tell me proceedure
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
explan ur project architecture?
What is a shortcut and copy in Informatica and how two are different with each other?
How to retrieve last two days updated records?
what is incremental data aggregation?
What is the benefit of partitioning a session?
what are objects in data warehouse?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
what is diff b/t sorter t/r and agg have the option sorter property...
What is the difference between warehouse key and surrogate key?
Teradata 
