Answer Posted / murali

JOINER
TRANSFORMATION:

to join source data from two related heterogeneous sources
residing in different locations or file systems. Or, you
can join data from the same source.


If you need to join more than two sources, you can add more
Joiner transformations to the
mapping.



You cannot use a Joiner transformation in the following
situations:
Either input pipeline contains an Update Strategy
transformation.
You connect a Sequence Generator transformation directly
before the Joiner transformation.

UNION
TRANSFORMATION:




The Union transformation is a multiple input group
transformation that you can use to merge data from multiple
pipelines or pipeline branches into one pipeline branch.

The Union transformation merges sources with matching ports
and outputs the data from one output group with the same
ports as the input groups.
Similar to the UNION ALL statement, the Union
transformation does not remove duplicate rows.

Tell me about MD5 functions in informatica

919

---

What is session task and command task?

1264

---

What is olap (on-line analytical processing?

1055

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2046

---

Write the advantages of partitioning a session?

1259

---

In how many ways we can create ports?

1108

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1061

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2189

---

What is expression transformation?

1086

---

Explain incremental aggregation in informatica

1109

---

Differentiate between a database and data warehouse?

1128

---

What is the use of an aggregator cache file?

1181

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2027

---

What are the informatica performance improvement tips

1069

---

What you know about transaction control transformation?

980

---