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
- 6713 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 in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How can you generate reports in informatica?
Define update strategy?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Separate from an archive server and a powerhouse?
how to load dimension table and fact table. plz tell me the steps.
What is native users?
Enlist some properties of sessions.
What is a joiner transformation?
What is the benefit of session partitioning?
What differs when we choose the sorted input for aggregator transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is meant by lookup transformation?
What is the Process to creating lookup transformation in informatica
Is there any way to read the ms excel datas directly into informatica?
