Interested to Buy Any Domain ? << Click Here >> for more details...
what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
- 3 Answers
- 6975 Views
- I also Faced
- E-Mail Answers
Answer Posted / sridhar
if u using star schema to u have to develop the dim tables depends on requirement(like scd1,2,3) then u have to look up on all dim tables using natural keys,when the session time u have to load dim's are sequence process like (s1-s2-s3-s4--eventraise)then all success u can load fact load by using eventwait in concurent manner.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is lookup transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to convert multiple rows to single row (multiple columns) in informatica
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is aggregate cache in aggregator transformation?
What is the benefit of partitioning a session?
What is an Integration service in Informatica?
Explain in detail scd type 2 through mapping.
What is union transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Differentiate between reusable transformation and mapplet.
What is a mapplet/worklet in informatica?
What is the sequence generator transformation in informatica?
What are the new features of informatica 9.x developer?
