Answer / 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....

Answer / madhu

we can use sourcequalifier transformation
or union transformation to combine different source to a
single source

Answer / rkumar.etl

use union transformation or you can write sql override if
you have advance knowledge of table join conditions for the
current database.

What is the difference between informatica 7.0 and 8.0?

0 Answers  

---

What are the tasks that can be performed using sq?

0 Answers  

---

what is materialized view?

2 Answers  

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

How to elaborate tracing level?

0 Answers  

---

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---