Interested to Buy Any Domain ? << Click Here >> for more details...
how to answer the question "explain project architecture" in
informatica
pls any one who has the answer pls send the answer to this
mail id
"karumanchisrinu@gmail.com
- 2 Answers
- 17945 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / asdf
Source systems: like mainframe,oracle,people soft,db2.
2. Landing tables: these are tables act like source. Used
For easy to access, for backup purpose, as reusable for
Other mappings.
3. Staging tables: from landing tables we extract the data
Into staging tables after all validations done on the data.
4. Dimension/facts: these are the tables those are used for analysis and make decisions by analyzing the data.
5. Aggregation tables: these tables have summarized data
Useful for managers who wants to view monthly wise sales,year wise sales etc.
6. Reporting layer: 4 and 5 phases are useful for reporting developers to generate reports. I hope this answer helps you.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to connect to a flatfile through ftp in informatica
What are snapshots?
What is data modeling and data mining?
What do you understand by the term ‘transformation’?
What are the steps involved in etl process?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Explain me ETL project architecture in Detail?
what is dynamic insert?
what is the difference steps for data modeling?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
list and discuss two approaches for updation of target table in Informatica and how they are different.
how would u estimate the size of Aggregator transform data and index cache?
Which transformation we use to convert 'NA' to 'Not Available'
explain the methodology of Data Warehousing?(Polaries)
what are the production issues in datastage?
