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
- 5749 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 |
What are the two modes of datamovement in informatica sever?
Explain the types of transformations?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
what is bitmap index? did u use it?and how to use it in informatica
what is procedure to use mapping variable in source qualifier transformation? with example
What is rank index in rank transformation?
How to retrieve last two days updated records?
How to do Integration testing in Informatica?
What is A complex mapping?
What is sequence generator transformation in informatica?
Normalizer transformation is not involved in Mapplet.. why???
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
Teradata 
