Answer Posted / surya

new features in informatica 7.1 was

1. union transformation is added
2. custom ,, ,,
3. we can take flat file as lookup table
4.pmcmd command
5. server grid
6. transaction controle transformation
7. file repository concept
8.test load

How many ways are there to do 'remove duplicate records in informatica'?

1027

---

What is the difference between Active and Passive transformation?

1166

---

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

2183

---

What do mean by local and global repository?

1235

---

how tokens will generate?

2210

---

tell me the rules and responsblites in our project(my project is development)

1941

---

What is a router transformation?

1138

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1514

---

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

1873

---

Enlist the various types of transformations.

1070

---

What is dimensional table? Explain the different dimensions.

1179

---

how to load rows into fact table in data warehouse

1202

---

write a query to retrieve the latest records from the table sorted by version(scd)

1081

---

Why sorter is an active transformation?

1206

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2139

---