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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?

Question Posted / guest

Answers were Sorted based on User's Feedback



what is the logic will you implement to laod the data in to one factv from 'n' number of..

Answer / 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

what is the logic will you implement to laod the data in to one factv from 'n' number of..

Answer / adisekhar

BY USING JIONER TRANSFOMATION WE CAN LOAD

Is This Answer Correct ?    0 Yes 2 No

what is the logic will you implement to laod the data in to one factv from 'n' number of..

Answer / seshagiri k

By using Target load order plan and based on primary foreign
keys to load the data into n no of dimensions



If it wrong pls send the correct answer to my mail

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More Informatica Interview Questions

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

Describe expression transformation?

0 Answers  

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories