Answer Posted / sunil

when lookup cahing is unabled, informatica server queries
the lookup table once,caches the lookup values during
session.This can inprove session performance.

when u disable lookup caching,each time row pass to the
transformation,informatica server issues an select
statement to lookup table for lookup values

Explain direct and indirect flat file loading (source file type) - informatica

1320

---

How to update or delete the rows in a target, which do not have key fields?

1180

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1056

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1276

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2521

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2146

---

How to generate sequence numbers without using the sequence generator transformation?

1212

---

What is source qualifier transformation in informatica?

1013

---

Explain the use of aggregator cache file?

1258

---

What all join we can perform in LOOKUP transformation?

978

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1963

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1785

---

Explain the different kinds of facts.

984

---

How can we use mapping variables in informatica? Where do we use them?

1205

---

What is substr in informatica?

1210

---