Answer Posted / infa

using iif and isnull functions in expression

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1971

---

What are the different clients of powercenter?

1006

---

What is the format of informatica objects in a repository?

972

---

Explain in detail scd type 2 through mapping.

985

---

What is the difference between a repository server and a powerhouse?

1410

---

How can you differentiate between powercenter and power map?

1017

---

Explain lookup transformation source types in informatica

1039

---

How can we delete duplicate rows from flat files?

1161

---

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

1804

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4676

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1995

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2319

---

On which transformations you created partitions in your project?

1249

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2263

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1071

---