Can we combine a flatfile and a database table using an
UNION transformation?
Answer Posted / surya
You can connect heterogeneous sources to a Union transformation.The transformation merges sources with matching ports and outputs the data from one output group with the same ports as the input groups
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is xml source qualifier transformation in informatica?
What is a pre-defined event and user-defined event?
Explain scd type 3 through mapping.
What are the new features of informatica 9.x in developer level?
Write the program through which the records can be updated?
What is the function of aggregator transformation?
is it possible to index the data in cache of lkp transformation ?
Explain load alternative records / rows into multiple targets - informatica
What are the various types of transformation?
What is sequence generator transformation in informatica?
What does update strategy mean, and what are the different option of it?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain the use of aggregator cache file?
What is the need of an ETL tool?
Write the unconnected lookup syntax and how to return more than one column.