What is the difference between IN and Exists in Oracle?

4 Answers   Deloitte,

---

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

How to add source flat file header into target file?

3 Answers   Logica CMG,

---

What is meant by a domain?

0 Answers  

---

What are junk dimensions?

0 Answers  

---

what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

What is main use of mapplet?

0 Answers  

---

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  

---

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---

What is a rank transform?

0 Answers  

---

Why union transformation is an active transformation?

0 Answers   Informatica,

---