Answer Posted / saritha

craete a dummy table create table abc(source_name varchar2
(10),count number);

write a sp create or replace prod name

select count(*) into v1 from table name

insert into abc ( 'dvhadvav',v1);
commit;
end

import that sp in the maping and slecte the pro as sorce
pre load.

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

1111

---

How can we remove the duplicates from flat file source?

1040

---

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

1054

---

Enlist some properties of sessions.

1076

---

What all join we can perform in LOOKUP transformation?

978

---

What is mapping debugger?

1017

---

Is it possible to use a client with different version than that of its Informatica server?

1143

---

What is Session and Batches?

1108

---

How does a sorter cache works?

1072

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1294

---

How to delete duplicate row using informatica?

1047

---

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?

1105

---

Why union transformation is an active transformation?

1048

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2067

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1063

---