Answer Posted / sharad sharma
The simple ligic of Union is that, It capture all the
unique recorde from bothe the source.
suppose if you have 10 records in table A and 10 records in
table B, in which 3 records are same in both the tables.
Then after using the Union transformation you will get 17
records, as the rescords which are getting duplicated will
not be in the output.
| Is This Answer Correct ? | 5 Yes | 47 No |
Post New Answer View All Answers
How to create the source and target database connections in server manager?
Mention few power centre client applications with their basic purpose?
Under which circumstances, informatica server creates reject files?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
tell me the rules and responsblites in our project(my project is development)
How to load data in informatica ?
What could be the possible resons of locks by user?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
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
Can we get 1st record through Informatica(without sequence number).
How to use procedural logic inside infromatica?
Have you worked with/created Parameter file
Explain what is informatica metadata and where is it stored?
server hot-ws270 is connect to Repository B. What does it mean?
What are batches?