Answer / ratalarayudu

hi,

The main purpose of unconnected lookup t/r is

1.To update slowly changing dimensions
2.if we want to use the same lookup multiple times in a
mapping we can go for unconnected lookup
3.if we want to lookup on only selected rows then we can go
for unconnected look up.

regards,
rayudu.

Answer / praveenabhaskar

We can use unconnected lookup transformation when we have
multiple inputs and single output.

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,

---

What is the difference Between Mapping parameter and variable

3 Answers   Accenture,

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

---

In development project what is the process to follow for an etl developer from day1

0 Answers  

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

How can a transformation be made reusable?

0 Answers   Informatica,

---

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---