what is distinct

4 Answers  

---

Describe the impact of several join conditions and join order in a joiner transformation?

1 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,

---

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1 Answers  

---

Mention a few design and development best practices for informatica?

1 Answers  

---

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

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,

---

How mapping parameter and variable works

1 Answers  

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

---