What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
1014How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
1506How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
1056I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
1101Post New Informatica Questions
How big was your fact table
Which files are created during the session rums by informatics server?
How does a sorter cache works?
What is target designer and target load order?
What is workflow manager?
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
Explian the Process of deployment groups in informatica
What does role playing dimension mean?
Explain pushdown optimization and types in informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How do you load alternate records into different tables through mapping flow?
Explain what transformation and how many are there in informatica?
What are the databases that informatica can connect to windows?
explain about unit testing? in real time?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?