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 will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  

---

how can u tune u r informatica mapppings

2 Answers   CTS,

---

What do think which one is the better joiner or look up?

0 Answers  

---

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

---

What is a filter transformation?

0 Answers  

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

---

What is dynamic cache?

0 Answers  

---

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,

---

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

How to run a session, which contains mapplet?

1 Answers  

---