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 is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2071

---

What is a surrogate key?

1027

---

Can we create a Integration service without a Repository service and vice versa?

1180

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

959

---

What is a repository manager?

1039

---

Explain what transformation and how many are there in informatica?

899

---

What is a sequence generator transformation?

960

---

How to improve the performance of a session using sorter transformation?

1103

---

Explain lookup transformation source types in informatica

1051

---

What is a code page?

1126

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2092

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2199

---

What is Data Caches size?

1044

---

What are the performance considerations when working with aggregator transformation?

1103

---

How do you load first and last records into target table?

1111

---