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 the dimensions will be loaded?

0 Answers   HCL,

---

What are the modules in Power Center

0 Answers  

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---

What is fact table? Explain the different kinds of facts.

0 Answers  

---

What is lookup change?

0 Answers  

---

How to use procedural logic inside infromatica?

0 Answers  

---

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

---

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---