Why the UNION TRANSFERMATION is an Active TRANSFERMATION
Answer Posted / chanakya
In Union Transformation we may combine the data from two
(or) more sources. Assume Table-1 contains '10' rows and
Table-2 contains '20' rows. If we combine the rows of
Table-1 and Table-2 we will get a total of '30' rows in the
Target. So it is definitely an Active Transformation.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
Where is metadata stored?
what is the size of u r source(like file or table)?
What are the new features of informatica 9.x at the developer level?
Differentiate between a repository server and a powerhouse?
What is the use of an aggregator cache file?
Enlist some properties of sessions.
Mention some types of transformation?
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?
What do you understand by term role-playing dimension?
What are the different options available for update strategy?
What is meant by pre and post session shell command?
According to his methodology what all you need before you build a datawarehouse
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to go to the older version for a mapping?