Answer Posted / naidu.k

Connected Lookup
Its can recieve multiple input ports and returns
multiplepoutputorts
it is part of mapping data flow
when lookup condition no match Data the integration services
returns insert the data
when lookup condition match Data The integration services
returns update the Data
default values supports
UNConnected Lookup
Its not part of mapping data flow it can recieve multiple
input ports and return single output ports.
when lookup condition no match data the integration services
returns null values
when lookup condition matchdata the integration srvices
returns update data
default values removed
I

Explain your project of banking domian.

1653

---

What are the differences between oltp and olap?

972

---

What is the need of etl tools?

1120

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7249

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4111

---

How will the document be delivered to me?

1085

---

What is an aggregator transformation?

1098

---

How to do unit testing in informatica? How to load data in informatica ?

1123

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554

---

Explain in detail scd type 2 through mapping.

1045

---

lookup transformation with screenshots

4006

---

How can a transformation be made reusable?

1171

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2365

---

COM components can be used in Informatica

2395

---

How many numbers of sessions can one group in batches?

1064

---