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.

How would you join a node to the already existing domain?

1066

---

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

1068

---

Define joiner transformation?

986

---

What is aggregator transformation in informatica?

896

---

What is meant by a domain?

1078

---

expain about the tune parameters?

2338

---

Plz can any one say me how to get the informatica certification materials and dumps

1999

---

Separate from a database, an information bazaar, and an information stockroom?

1011

---

What is Cognos script editor?

4163

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5683

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1023

---

What are the databases that informatica can connect to windows?

1001

---

What are the main features of Oracle 8i with context to datawarehouse?

2052

---

What are the new features of informatica 9.x in developer level?

937

---

What does role playing dimension mean?

997

---