Answer Posted / yash
data mart are specific ,repository of data, designed to
answer specific users.( examaple :sales)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
State the limitations where we cannot use joiner in the mapping pipeline?
can anyone explain me about retail domain project in informatica?
How to implement security measures using repository manager?
whats the logic to load the lower level of granularity of data to fact table.
How to delete duplicate row using informatica?
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.
What are the differences between joiner transformation and source qualifier transformation?
What is lookup transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain the different lookup methods used in informatica?
What is the Rank index port in Rank transformation?
Explain the code page compatibility?
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
