Answer / hari

Parameter file is text file which contains mapping variables and mapping parameters for mappings , sessions an workflows.

Diffrence between static and dynamic cache

2 Answers   HCL,

---

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,

---

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,

---

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,

---

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---

How to improve the session performance in informatica?

3 Answers   Accenture,

---

what is target update override and when we use it?

2 Answers   TCS,

---

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

---