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
- 6954 Views
- Amdocs, I also Faced
- E-Mail Answers
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
can we override a native sql query within informatica? Where do we do it? How do we do it?
How does the aggregator transformation handle null values?
Where do we use mapping variables in informatica?
What is the difference between a repository server and a powerhouse?
What are the types of schemas we have in data warehouse and what are the difference between them?
what is song in infrmatica...?
Please let me know how to make encryption and decryption with example?
How do you migrate data from one environment to another?
Tell me about Propagate functions in informatica
what are the deliverables?in your project?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How can you increase the performance in joiner transformation?
What are the new features of informatica 9.x in developer level?
Explain what is informatica metadata and where is it stored?
Write the unconnected lookup syntax and how to return more than one column.
