Interested to Buy Any Domain ? << Click Here >> for more details...
who to split dimentions into sub dimention
- 3 Answers
- 7315 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinu
make required column as primary-forign key relation then add
fields wt do u want
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vino
i Think,
You can split the dimension tables into two and can join
the two separate dimemsion tables by the surrogate key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kittu
It is clearly apt for snowflake schema because in snow flake schema dimension table are further splits the de-normalized table into small normalized dimensions to decrease the table space and also to increase the performance this can be done with help on foreign key and primary key constraints
| Is This Answer Correct ? | 0 Yes | 0 No |
tell me 5 session failure in real time how can you solve that in your project?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
what is fact and what types of fact tables is there
What is pmcmd command?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
how will you remove the duplicate records from flat file without using sorter?
how to convert the .doc docs into .txt format using informatica
How can we store previous session logs?
what is the architecture of any Data warehousing project?
How to do unit testing in informatica? How to load data in informatica ?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
Teradata 
