Answer Posted / ram reddy

Update Override it is an option available in TARGET
instance.By defalut Target table is updated based on
Primary key values.To update the Target table on non
primary key values u can generate the default Querey and
override the Querey according to the requiremnet.Suppose
for example u want to update the record in target table
When a column value='AAA' then u can include this condition
in where clause of default Querey.

Coming to SQL override it is an option available in Source
Qualifier and Lookup transafornmation where u can inlude
joins ,filters,Group by and order by.

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105

---

How many ways are there to create ports?

1332

---

Explain the shared cache and re-cache?

1116

---

What is rank index in rank transformation?

1080

---

Briefly describe lookup transformation?

1046

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036

---

What is sorter transformation?

1045

---

What is the status code in stored procedure transformation?

1182

---

Performance tuning in UNIX for informatica mappings?

2568

---

What is a joiner transformation?

996

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2199

---

What is a transaction control transformation?

1208

---

wat are deployement groups in informatica, how it will be used for developers

1719

---

can we override a native sql query within informatica? Where do we do it?

1122

---