Answer Posted / rama

select (distinct max(sal)) from emp

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2001

---

can u give example for factless fact table

6648

---

What are the static cache and dynamic cache in informatica?

1192

---

State the limitations where we cannot use joiner in the mapping pipeline?

1067

---

What is event and what are the tasks related to it?

1122

---

Explain the types of transformations?

1068

---

wf dont have integration severances how you can run?

1938

---

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

1863

---

can anyone explain me about retail domain project in informatica?

7947

---

whats the logic to load the lower level of granularity of data to fact table.

2276

---

What is a dimensional model?

980

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1932

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

---

which one is better performance wise joiner or look up

1093

---

explain abt ur project architecture?

2193

---