Multiple choice technology databases

We can use the joiner in case of?

  1. Joining two flat files

  2. To join two table from different data bases

  3. To join flat file and relational table

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Joiner transformation in PowerCenter can join heterogeneous data sources: two flat files, tables from different databases, or a flat file with a relational source. Joiner is designed specifically for joining data from different sources or types, which is why 'All of the above' is correct. It performs the join in Informatica's memory rather than pushing it to a database.

Keep practicing — related questions