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 best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

What is galaxy shema

2 Answers   CGI,

---

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

---

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---

What is rank transform?

0 Answers  

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

---

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---