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.

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

---

How can we eliminate duplicate rows from flatfile,explain?

3 Answers  

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

Name 4 output files that informatica server creates during session running?

1 Answers  

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

Define filter transformation?

0 Answers  

---

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

---

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

---

what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

---

Enlist the advantages of informatica.

0 Answers  

---

what are surrogate keys?

5 Answers  

---