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
- 6861 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 |
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
What are the features of complex mapping?
How many numbers of sessions can one group in batches?
need for registering a repository server
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
Is it possible to have "5 source & 5 Target" in single mapping?
what is shared Cache. when we will use shared Cache?
Why sorter is an active transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is constraint based loading
Teradata 
