What is factless fact schema?
Answer / mln
The fact which does not contain any facts or mesaurables.
Ex:the fact table which is used to store the students
information is he came to school or not cannot have weather
they are attending all classes.
which is a measure
| Is This Answer Correct ? | 5 Yes | 4 No |
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
Explain about Informatica server process that how it works relates to mapping variables?
What is a passive transformation?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
How do you change a non-reusable transformation to reusable transformation?
What is fact table? Explain the different kinds of facts.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is junk dimension
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
What are the types of lookup transformation?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?