What is Micro Strategy? Why is it used for?

5 Answers   Infosys,

---

how many types transformations supported by sortedinput?

4 Answers  

---

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

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

0 Answers   IBM,

---

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

---

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

---

Explain pmcmd command usage in informatica

0 Answers   Informatica,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

---

what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  

---