Answer Posted / rams

yes

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1165

---

What are connected or unconnected transformations?

1119

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2302

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1275

---

Where can we find the throughput option in informatica?

1059

---

How does a sorter cache works?

1067

---

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

1861

---

Please let me know how to make encryption and decryption with example?

1900

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1763

---

What is a rank transform?

1084

---

According to his methodology what all you need before you build a datawarehouse

1755

---

What are the tasks that can be performed using sq?

1091

---

What are roles and groups and benefits of using them?

1055

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1122

---

Performance tuning( what you did in performance tuning)

1979

---