Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How are indexes created after completing the load process?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
In development project what is the process to follow for an etl developer from day1
How can a transformation be made reusable?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a router transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is a joiner transformation?
Why update strategy and union transformations are active? Explain with examples.
Explain sessions?
Explain the different lookup methods used in informatica?
without table how to come first record only in oracle?
