two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

What is degenerated dimention table?

7 Answers   Patni,

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

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,

---

what is left outer join?

3 Answers   L&T,

---

Explain the aggregator transformation?

0 Answers  

---

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

0 Answers  

---

What do mean by local and global repository?

0 Answers  

---

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

---

How to view and Generate Metadata Reports?

1 Answers  

---