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 rank index in rank transformation?
What are the advantages of using informatica as an etl tool over teradata?
What does cheating measurement mean?
What is DR strategy for Informatica project?
What do you mean by enterprise data warehousing?
What does reusable transformation mean?
How do you change a non-reusable transformation to reusable transformation?
Did u used latest transformations of 8.6.0? for what?
How can we delete duplicate rows from flat files?
Please let me know how to make encryption and decryption with example?
What is data caches/ index caches?
How to partition the Session?
can you please explain me pre session and post session options?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?