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
- 6959 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 |
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what is shortcut in informatica? difference between shortcut,reusable object?
What is mapping debugger?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
How you load distinct records into one target and duplicate records into another target?
how can we check whether a particular cache is static or dynamic?
What is the status code in stored procedure transformation?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
What are mapplets?
What all are steps in up gradation of Informatica server?
What are the new features of informatica 9.x at the developer level?
How to delete duplicate records in a flat file source?
Teradata 
