Interested to Buy Any Domain ? << Click Here >> for more details...
Does Facttable Normalized or Denormalized?
- 2 Answers
- 8250 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Fact tables are normalized. Dimension tables are denormalized
| Is This Answer Correct ? | 27 Yes | 0 No |
what is the exact meaning of domain?
How many transformations can be used in mapplets.
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
Enlist the tasks for which source qualifier transformation is used.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
permutations of mapplet
What the difference is between a database, a data warehouse and a data mart?
What are the types of caches in lookup?
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
Teradata 
