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.

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

what is row level and column level indicator?

1 Answers   TCS,

---

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

---

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

---

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

---

What is query panel?

1 Answers  

---

Why we require dwh in particular projects?

1 Answers   Amdocs,

---

difference between repository database and repository service?

0 Answers  

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

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

3 Answers   HCL,

---

What are the different tools in workflow manager?

1 Answers  

---