Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10610 Views
- Cap Gemini, Puma, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sridhar
factless fact table is a fact table but table does n't have
any facts for measurement for e.g student attendance in a
class, if we have 100 members in a class we can perform the
calculations like marks,grades but you cannot measure for
student attendance.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
If informatica has its scheduler why using third party scheduler?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the different transaction levels available in transaction control transformation?
Explain the types of lookup transformation?
What are the different versions of informatica?
What is transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How many ways are there to do 'remove duplicate records in informatica'?
What is decode in informatica?
What can we do to improve the performance of informatica aggregator transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Informatica settings are available in which file?
What is an Integration service in Informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
