Answer Posted / pooja

hi,

please get clear picture on the Question...
1. wherther all 3 source are in same schma or in differt
schme ..
if its in differnt schma means use joiner
if its same schma means u cn override the SQ query
2. if no.of columne and datatype are same for all the 3
source means you can use union trans....

explain abt ur project architecture?

2197

---

Explain in detail scd type 2 through mapping.

1045

---

Do you find any difficulty while working with flat files as source and target?

1098

---

How might you approve all mappings in the archive all the while?

1018

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9827

---

What do you understand by a term domain?

1125

---

How union transformation is used?

1008

---

Differentiate between reusable transformation and mapplet.

1100

---

draw informatica architecture 8.6 ?

3874

---

How are the sources and targets definitions imported in informatica designer?

1107

---

How to convert multiple rows to single row (multiple columns) in informatica

1384

---

How can we use batches?

1025

---

what is degenerated dimension?

3998

---

What is the benefit of session partitioning?

1116

---

How to improve the performance of a session using sorter transformation?

1148

---