Answer / srinu

Hai KPIT,, My Ans will Show you the Way,,,,,,

1) Performance Issue in Informatica: In your
Project ,My Project,,,Any Project Mostly our final
Target was Loading the Data in to Target Table, under
Efficiently in Less time.
Tune the Mapping, Less Active Transformations,Use Best
Loading Option,
Partition the Data,Index less Target Table,,,,,


2)Yes, we drop the index and disable the constraint Perform
Better,That loads the Data based on the Particicular Table
only,Else I will go for Parent,Child test in FK
Relation,Condition in constraint,,,After Loading the Data
You can Configure indexes, constraints on Table.


3)SED-commands,AWK-commands,Dir Commands,File Commands,Copy
Commands only,,

Thanks
Srinu.srinuvas@gmail.com

What are the phases in SDLC?

3 Answers  

---

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

---

What is the cumulative sum and moving sum?

0 Answers  

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

Major difference between SQL override and Lookup Sql override

1 Answers  

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

---

In dimension and fact table? which one holds big data?

2 Answers  

---

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

---

How many input parameters can exist in an unconnected lookup?

0 Answers  

---

explain abt joiner t/r?

1 Answers   IBM,

---