What is the main difference between a Joiner Transformation
and Union Transformation?
Answer Posted / medatati satya teja ravi kiran
UNION:1)we can create multiple input groups,but only one
out put group
2)we can connect heterogeneous sources to a union
transformation
3)The union tf does not remove duplicate rows.To remove
duplicte rows, we must add another tf such as router or
filter tf
JOIN:1)Used to join source data from two related
hetorogeneous sources residing in different locations or we
can join data from the same source
2)The joiner tf remove duplicate rows...
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What do you understand by SOA of Informatica?
How does a sorter cache works?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Plz can any one say me how to get the informatica certification materials and dumps
How can we use mapping variables in informatica? Where do we use them?
What is meant by pre and post session shell command?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to start a workflow using pmcmd command?
What is meant by LDAP users?
Differentiate between reusable transformation and mapplet.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Write the program through which the records can be updated?
What is olap (on-line analytical processing?