Answer Posted / rahul

use sorter trans

What is a code page?

1177

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2065

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---

can we override a native sql query within informatica? How do we do it?

1126

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1079

---

What is the difference between Active and Passive transformation?

1152

---

permutations of mapplet

2511

---

What is Index Caches size?

1114

---

Whats there in global repository

1692

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4160

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3870

---

What are the different types of olap? Give an example?

1053

---

What is source qualifier transformation in informatica?

1009

---

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

1068

---

What are the tuning techniques you applied during your last project

2024

---