Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amit
fact table is collection of all facts in the dimension
facys is nothing but quantitative data
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
In how many ways we can create ports?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain the different dimensions.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is repository manager?
Explain the features of connected and unconnected lookup.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Enlist the tasks for which source qualifier transformation is used.
Differentiate between sessions and batches?
How to extract the informatica rejected data?
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
