Answer / hari

to look at the explain plan of the sql query which is issue
to database from infomatica.
have a look at the user_indexes with
table_name=<<TABLENMAE>>
have a look at user_tab_partition where
table_name=<<TABLE_NAME>>
TABLENAME, which are used in the informatica sql query...

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  

---

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

---

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,

---

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

---

What is the function of aggregator transformation?

0 Answers  

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

---

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

---

What is active and passive transformation?

10 Answers  

---

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---