Answer Posted / srik

5m => 5 million recors.

1) Since target side records are very huge compared to
the source, caching is not preffred. so No caching.

2) Again with no caching we can accomplsh this in 2 ways
a) By Joiner
b) Unconnected lookup
but as unconnected lookup is not in answers is in the
option, Joiner is the answer

What is workflow? What are the components of workflow manager?

701

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1548

---

Explain lookup transformation in informatica

640

---

Repository user profiles

1370

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1197

---

---

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

3438

---

Explain sessions. Explain how batches are used to combine executions?

585

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

626

---

How identifying bottlenecks in various components of informatica and resolving them?

575

---

what is INFORMATICA TESTING process

1832

---

Is it possible to define a single node as a Gateway node as well as worker node?

646

---

explain about unit testing? in real time?

1650

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

627

---

What is expression transformation?

623

---

Differentiate between reusable transformation and mapplet.

560

---