Answer / priyank

There are some keys which are present in the fact table but
they do not have a corresponding Dimension table related to
them. These are called Degenerated Dimensions.

Eg. Transaction No., Invoice No.

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

Is it possible to use a client with different version than that of its Informatica server?

0 Answers  

---

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

---

How to load a relational source into file taget?

2 Answers  

---

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

---

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

0 Answers  

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

Where are the source flat files kept before running the session?

0 Answers   Informatica,

---

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  

---

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---