Answer / suraj kedia

A union transformation is a multiple input group
transformation,which is used to merge the data from multiple
sources similar to UNION All SQL statements to combine the
results from 2 or more sql statements.
Similar to UNION All statement, the union transformation
doesn't remove duplicate rows.

It is an active transformation.

What are some examples of informatica etl programs?

0 Answers  

---

why we r using presql&postsql in source qualifier?

1 Answers   HP,

---

how to we create datamart?

2 Answers   HSBC,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

Can we create out put ports in source qualifier t/r?

5 Answers   TCS,

---

What is native users?

0 Answers  

---

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 ?

0 Answers   Puma,

---

Which will beter perform IIf or decode?

3 Answers   TCS,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

---