Answer / venkat

Use aggregator transformation for getting number of record
count from source.

Answer / nagaraju

count(*) from table;

Answer / 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 to create Target definition for flat files?

0 Answers   Informatica,

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---

What is the Hierarchy of DWH?

1 Answers  

---

scenario

1 Answers  

---

How to improve the session performance in informatica?

3 Answers   Accenture,

---

---

What is difference between a connected look up and unconnected look up?

6 Answers  

---

What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  

---

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,

---

What is a configuration management?

1 Answers  

---

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

---

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

---

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

---