Explain factlessfact table with scenario
Answer / tamilarasan
Factless fact table - it doesn't have any measures
There are types in this
Additive : we can calculate all the aggregate function in this
Semi: we can do only particular calculation
Non : no calculation can be done
| Is This Answer Correct ? | 0 Yes | 0 No |
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Can we create a node as a gateway node and the same node can be assigned to a grid?
what is the difference between stop and abort?
Which files are created during the session rums by informatics server?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
How many joins in Informatica
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
how we can load rejected record's at run time?(not through bad files)
what is target load plan
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that