Answer / isha

Yes.

Uncheck the 'lookup cache enabled" option. It will become un-cached lookup and will fire query on DB directly... It is not a good idea at all. Cache always increases speed of execution.

How to load last n records of file into target table - informatica

0 Answers   Informatica,

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

What is the need of building a data warehouse?

2 Answers  

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

---

What are mapplets?

0 Answers  

---

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

---

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

---

Can you create a flatfile target

3 Answers   ABC,

---