in which situations do u go for starflake schema ?
Answer Posted / prabakaran
when we have single or multiple facts and not bothered
about query performance.
When we dont have disk storage limitations
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are the tasks that source qualifier perform?
Which files are created during the session rums by informatics server?
How to join three sources using joiner? Explain though mapping flow.
In how many ways we can create ports?
What is a standalone command task?
Which development components of informatica have the highest usage?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How can we use batches?
How to generate sequence numbers without using the sequence generator transformation?
What is meant by pre and post session shell command?
What are the different types of repositories created using informatica?
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
Explain Dataware house architecture .how data flow from intial to end?
What is informatica metadata and where is it stored?