Answer Posted / krishraj
It is simple logic, UNION fectches the commmon records
between two tables and it emliminated un-common records. So
it will be Active transformation which means it will change
the number of records.
Any other answers please....
| Is This Answer Correct ? | 1 Yes | 38 No |
Post New Answer View All Answers
How do we call shell scripts from informatica?
Is there any target staging area in informatica not staging area
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the types of schemas we have in data warehouse and what are the difference between them?
Define the various join types of joiner transformation?
Implementation methodology
Explain lookup transformation in informatica
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Why sorter is an active transformation?
Where do we use mapping variables in informatica?
What are the tuning techniques you applied during your last project
What is persistent lookup cache?
What is target designer and target load order?
Can you generate sequence numbers without using the sequence generator transformation?