Answer Posted / arpan

Select empid,monthyear,sal from empsal
where sal>100000
orderby monthyear;

What is the different lookup cache(s)?

1037

---

 Informatica Checkpoints

3273

---

Briefly describe lookup transformation?

985

---

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

1667

---

What is the fact table?

998

---

How to delete duplicate row using informatica?

986

---

What are the advantages of using informatica as an etl tool over teradata?

976

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1634

---

Explain the informatica workflow?

1008

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1022

---

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

1809

---

What are the features of complex mapping?

1102

---

What are the differences between a connected lookup and unconnected lookup?

1018

---

What are the static cache and dynamic cache in informatica?

1141

---

How to create or import flat file definition in to the warehouse designer?

1026

---