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 target designer and target load order?
Partition, what happens if the specified key range is shorter and longer
What is option by which we can run all the sessions in a batch simultaneously?
Separate from a database, an information bazaar, and an information stockroom?
What is an unconnected transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Which files are created during the session rums by informatics server?
What is dynamic cache?
On which transformations you created partitions in your project?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the different options available for update strategy?
What do think which one is the better joiner or look up?
Reusable transformation and shortcut differences
To import the flat file definition into the designer where should the flat file be placed?
In informatica workflow manager, how many repositories can be created?