Answer Posted / vignesh muralidharan
The datas are kept in the data base
through the slowly changing dimension process.There are
three types in slowly changing dimensions:
type1,type2.type3.
| Is This Answer Correct ? | 12 Yes | 7 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what is the size of u r source(like file or table)?
Explain the informatica workflow?
Mention few advantages of router transformation over filter transformation.
Could you explain what is enterprise data warehouse?
How big was your fact table
Explain the aggregator transformation?
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
Describe data concatenation?
What is an Integration service in Informatica?
What is deployment group?
Differentiate between a database and data warehouse?
What does “tail –f” command do and what is its use as an Informatica admin.