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
- 6757 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer / 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 |
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
what is the complex transformation you used in informatica
If informatica has its scheduler why using third party scheduler?
What is a difference between complete, stop and abort?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
What is the function of aggregator transformation?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
What is meant by LDAP users?
Teradata 
