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.

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1887

---

Name the different lookup cache(s)?

691

---

What is expression transformation?

620

---

How do you change a non-reusable transformation to reusable transformation?

586

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1695

---

---

What is the status code in stored procedure transformation?

678

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1743

---

How can we delete duplicate rows from flat files?

730

---

What is exclusive and normal mode for repository services?

702

---

What is domain and gateway node?

683

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1672

---

what is informatica metadata?

587

---

What is the use of source qualifier?

658

---

Define mapping and session?

577

---

What are the differences between a connected lookup and unconnected lookup?

638

---