Answer Posted / afsar

Generally we check for busy percentage in session log if
its source busy % or Tgt% is more then we try to do
database tunning,if its transformance % is more then go for
Informatica part.But form my side I would rather suggest
for both kind of performance

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2035

---

where to store informatica rejected data?

1092

---

list out all the transformations which use cache?

1180

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1802

---

Explain in detail about scd type 1 through mapping.

1524

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2256

---

How to elaborate powercenter integration service?

1127

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1620

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1895

---

what is the size of your data warehousing?

2091

---

explain abt ur project architecture?

2184

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2173

---

Differentiate between sessions and batches?

1011

---

What are the different types of repositories created using informatica?

1115

---

What is confirmed fact in dataware housing?

6953

---