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.
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
What is update strategy transform?
Can u generate reports in Informatica?
What are Dimensional table?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the command used to run a batch?
What does update strategy mean, and what are the different option of it?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
While migrating the data from one environment to another environment how would you manage the connections?
Explain the difference between mapping parameter and mapping variable?
How are the sources and targets definitions imported in informatica designer?
have u done any performance tuning? how u ll do?
define galaxy repository in informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How can you generate reports in informatica?
Explain sessions?