Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

What are the popular informatica products?

1056


What do think which one is the better joiner or look up?

1246


What is the sql query overwrite in source qualifier in informatica

1142


How to delete duplicate row using informatica?

1089


Differentiate between reusable transformation and mapplet.

1142


How to use procedural logic inside infromatica?

1321


How can repository reports be accessed without sql or other transformations?

1268


Explain the use of aggregator cache file?

1317


wf dont have integration severances how you can run?

1987


What is the way to execute pl/sql script using informatica mapping?

1681


Enlist the differences between database and data warehouse.

1164


Write the unconnected lookup syntax?

1131


How many dimensions are there in informatica?

1134


What the difference is between a database, a data warehouse and a data mart?

1199


What are the various types of transformation?

1240