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.

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

Differnce between filter and router?

14 Answers   IBM,

---

What is a filter transformation?

0 Answers  

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---

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

0 Answers  

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,

---

How informatica recognizes mapping?

2 Answers   CTS,

---

what is incremental data aggregation?

3 Answers   IBM,

---

How to update records in Target, without using Update Strategy?

3 Answers  

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---