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 the procedure for creating independent data marts from informatica 7.1?
What is the sql query overwrite in source qualifier in informatica
Reusable transformation and shortcut differences
What are multi-group transformations?
How to extract sap data using informatica? What is abap? What are idocs?
What is a passive transformation?
What is olap (on-line analytical processing?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
without table how to come first record only in oracle?
Sequence generator, when you move from develoment to production how will you reset
What is confirmed fact in dataware housing?
What is a stored procedure transformation?
What is transformation?
How to Create a folder using pmrep command?