what is difference between dimention table and fact table?
Answer Posted / guest
dimensional table stores the textual description of data
whereas fact table stores numerical values.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
Separate from an archive server and a powerhouse?
Whats there in global repository
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the maplet?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How many types of sessions are there in informatica.please explain them?
How an expression transformation differs from aggregator transformation?
Separate from a database, an information bazaar, and an information stockroom?
What are the modules in Power Center
list out all the transformations which use cache?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain what are the different versions of informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project