Answer Posted / hania

Star Schama : easy for users to understand, optimize navigation and more suitable for query processing, and works faster.

Disadvantages: Dimension table have greater rows, large fact table

what is diff b/t sorter t/r and agg have the option sorter property...

2128

---

What is a connected transformation?

1042

---

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

1803

---

How many number of sessions can one group in batches?

1090

---

What is meant by lookup transformation?

1032

---

Enlist the advantages of informatica.

999

---

Differentiate between joiner and lookup transformation?

1045

---

Please let me know how to make Data masking in informatica..

1658

---

What is meant by pre and post session shell command?

1103

---

How do you load only null records into target? Explain through mapping flow.

1955

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6037

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2071

---

How many input parameters can exist in an unconnected lookup?

1489

---

What is intricate mapping?

1088

---

waht type of interface is used for testing the data in informatica

2190

---