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
- 5781 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
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the different lookup cache(s)?
can we override a native sql query within informatica? How do we do it?
What is data caches/ index caches?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a predefined event?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is decode in static cache?
what are the deliverables?in your project?
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?
Where do we use mapping variables in informatica?
what is informatica metadata?
Is it possible to define a single node as a Gateway node as well as worker node?
Make a note of the quantity vaults made in informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
