Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ghouse
to load the data into the fact table b tree index is created
and bit is used where the cordinality of the coloumn is very
low i.e(in dwh-denormalised one)(OLAP)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to generate sequence numbers using expression transformation?
What are session parameters ? How do you set them?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is a joiner transformation?
Explain constraint based loading in informatica
Please let me know how to make encryption and decryption with example?
What is the difference between stop and abort in informatica
where to store informatica rejected data?
How to extract sap data using informatica? What is abap? What are idocs?
What is pmcmd command?
how to load dimension table and fact table. plz tell me the steps.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How do you migrate data from one environment to another?
