Answer Posted / srinu

identification of bottelnecks
target:configuring session to write to flatfiletarget
source:add filter t/r after sq t/t to false show that no
data is processed past the filter t/r,if it time takes to
run new session remains same to the original session there
is source bottel necks
mapping:add filter t/f before each target and set filter
condition to false,similar to source
session:use the collect performance data to identify the
session bottel necks
read from desk,write to disk counters other than zero,there
is bottelnecks

Performance tuning( what you did in performance tuning)

2046

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1980

---

What is meant by pre and post session shell command?

1197

---

What is main use of mapplet?

1174

---

What is the scenario which compels informatica server to reject files?

1118

---

Explain pmcmd command usage in informatica

1178

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1790

---

What are the measure objects?

1249

---

Explain why we use partitioning the session in informatica?

1157

---

Is it possible to revert a global repository to local one and why?

1128

---

Explain about Informatica server process that how it works relates to mapping variables?

1121

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2169

---

what is degenerated dimension?

4090

---

Slowly changing dimensions, types and where will you use them

1767

---

Scheduling properties,whats the default (sequential)

2004

---