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
Explain what transformation and how many are there in informatica?
How to implement security measures using repository manager?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Why is sorter an active transformation?
In development project what is the process to follow for an etl developer from day1
Write the advantages of partitioning a session?
How to generate or load values in to the target table based on a column value using informatica etl tool.
is it possible to index the data in cache of lkp transformation ?
What is a joiner transformation and why it is an active one?
How can we improve session performance in aggregator transformation?
What do mean by local and global repository?
Under which circumstances, informatica server creates reject files?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How do you load alternate records into different tables through mapping flow?
difference between informatica 8.1.1 and 8.6