Answer / praveen sh

If the same lookup table is used multiple times in the same
mapping, then it is better to go for un connected lookup.
Doing so we save cache memory and enhence performence

Answer / shaik

1.to call the LKP more than once in a mapping.

Enlist the differences between database and data warehouse.

0 Answers  

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

---

can we generate reports in informatica ? How?

3 Answers  

---

What is resilience time?

0 Answers  

---

what is scd?

6 Answers  

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

What is staging area?

11 Answers  

---

What is the use of incremental aggregation?

2 Answers  

---

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,

---

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

---