In dimension and fact table? which one holds big data?
Answers were Sorted based on User's Feedback
Answer / ravikumar2614
Fact table having huge data with less colomns..
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / davankumar
Fact table has the big data bcoz fact table main tain
history data.
Is This Answer Correct ? | 2 Yes | 1 No |
How to handle decimal places while importing a flatfile into informatica?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
What are the new features of the server manager in the informatica 5.0?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
Can you generate reports in Informatcia?
Why we use partitioning the session in informatica?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
how can you load data into target table without leading zeor's
create a mapping to retrieve the employees who are getting salary greater than average salary?
In informatica workflow manager, how many repositories can be created?
what is the flat file partition and where have to specify it
can you avoid static cache in the lookup transformation? I mean can you