Answer / ajay konidena

we can't say how much we use .
it is depend on the project requirement so
u must have deep knowledge on both sql,plsql of any DB

Answer / chinni

If your'e well versed with Oracle. In performance point of
view use pre-sql and post-sql or sql query in source
qualifier transformation. If your'e having minimal
knowledge on sql or pl/sql then go for Informatica bcz its
a 3rd party tool which will give solutions in less time
than Normal Oracle.

What is a transaction control transformation?

0 Answers   Informatica,

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

---

What is InformaticaPowerCenter?

0 Answers   Informatica,

---

what is upstream and downstream transformation?

7 Answers  

---