Answer Posted / vijaya

by using Deocde or case expression get the above o/p

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5790

---

What are the data movement modes in informatica?

1152

---

Explain joiner transformation in informatica

1124

---

What is mapplet in informatica?

1057

---

what is the hint? how to use it to reduce the query processing in program?

7833

---

What is the Rank index port in Rank transformation?

1059

---

explain one complex mapping with logic? sales project?

6668

---

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.

2197

---

In informatica workflow manager, how many repositories can be created?

1361

---

What is olap (on-line analytical processing?

1069

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2136

---

How do you update the records with or without using update strategy?

1114

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1056

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2121

---

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

1203

---