Answer / rayudu

Connected lookup is used to lookup on each and every row
bjut unconnected lookup is used to lookup only when the
condition is true i,e unconnetcec is used only for selectetd
rows so obviously unconnected is faster .


Regards,
rayudu.

Answer / yamini

Performance wise unconnected look up transformation is better as it returns only one port and doesn't build any dynamic cache. Only static cache is build. It can be used any where in the mapping using LKP expression in another transformation.

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

---

what is upstream and downstream transformation?

7 Answers  

---

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

---

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

---