Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse
Answer Posted / dhana
Can anyone please tell me the No. of Fact table & Dimension tables usually used in a prjoect?I just need an example.Also the size of data warehouse?Is it in Terabyte of something?I just need an approximate size.
Thanks
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are active transformations.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain the use of aggregator cache file?
What happens when a session fails and you click on recover?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain what transformation and how many are there in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to update a particular record in target with out running whole workflow?
What are the various types of transformation?
How to load data in informatica ?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Write the different tools in the workflow manager?
How many types of sessions are there in informatica.please explain them?
What do you understand by SOA of Informatica?