what is the architecture of any Data warehousing project?
- 5 Answers
- 18561 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kumarapillaietl@gmail.com
first we integrate data into source to staging tables, from staging we movie into work table at the data moment of stage to work we do all transformation logic , then from work table we load data into fact and dimention table using scd 2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the size of your data warehousing?
What is a stored procedure transformation?
What are the modules in Power Center
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What differs when we choose the sorted input for aggregator transformation?
Explain transaction control transformation in informatica
Explain the different lookup methods used in informatica?
How to load the data from people soft hrm to people soft erm using informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain pushdown optimization $pushdownconfig parameter - informatica
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
How to extract sap data using informatica? What is abap? What are idocs?
How to generate sequence numbers without using the sequence generator transformation?
