Answer / pradeepreddygade

using Mystery Dimension you are maintaining the junk data in
your Project. Mystery Dimension are also known as Junk
Dimensions

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

How are parameters defined in informatica?

3 Answers   HP, TCS,

---

How do you load only null records into target? Explain through mapping flow.

0 Answers  

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

---

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

---

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

---