Answer Posted / ajay bhosal

Uncached lookup can give you good performance here but only when your target is properly indexed. Moreover, it's not a good idea to hit the database 100 times and scan huge data volume in the database.
Similar or better performance can be achieved by using Joiner with Sorted Input, but ensure that 100 rows are in master pipeline and the detail pipeline is sorted.
There is no question of using cached lookup.
Answer will be Joiner.

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4251

---

Where is metadata stored?

1190

---

How can we use mapping variables in informatica?

1123

---

What is a surrogate key?

1153

---

without table how to come first record only in oracle?

2301

---

Explain the types of lookup transformation?

1101

---

Explain Dataware house architecture .how data flow from intial to end?

2646

---

What is joiner transformation in informatica?

1098

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1986

---

How to go to the older version for a mapping?

1153

---

I have a flat file, want to reverse the contents of the flat file

1171

---

What are junk dimensions?

1111

---

How to create or import flat file definition in to the warehouse designer?

1130

---

What is the use of code page?

1171

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2407

---