Answer Posted / suneel reddy

Answers 1:
Depending upon the scenario we use the conn and unconn tr..

for e.g
In u r mapping u require same lkp multiple times, creating
lkp multiple times put it in flow is not a good idea, which
occupies more cache ...
Instead of that create one unconnectes lkp use multiple
times where ever u want , which very fast..

Answers 2:
u can use conn lookup but if u need 1 row so go for unconn
lookup coz u can
use it multiple time in same mapping from multiple
expression trn.
i hope it will help to u

How do you load unique records into one target table and duplicate records into a different target table?

1264

---

is it possible to index the data in cache of lkp transformation ?

2030

---

What do you understand by a term domain?

1126

---

What could be the possible resons of locks by user?

1095

---

What are some examples of informatica etl programs?

945

---

What are the popular informatica products?

1015

---

Which transformation should we use to normalise the COBOL and relational sources?

1215

---

How do you promote a non-reusable transformation to reusable transformation?

1138

---

How can we use mapping variables in informatica?

1065

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1811

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2137

---

how tokens will generate?

2208

---

EXL informatica Questions

1395

---

What is informatica etl tool?

1001

---

Explain joiner transformation in informatica

1128

---