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.

Can you generate reports in Informatcia?

1 Answers  

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

what is the difference between stop and abort?

3 Answers   TCS,

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  

---

What is the difference between stop and abort in informatica

0 Answers   Informatica,

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

Explain the shared cache and re-cache?

0 Answers  

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---