What types of data source(s) can be read with the source qualifier transformation?
Relational Databases
Relational Databases and flat files
Relational Databases,lat files and cobol
Relational Databases,lat files,cobol and certified ERP sources such as Peoplesoft and SAP R/3
Which activities below can be performed using Designer
Run the Debugger, validate mappings and mapplets, import source definitions
Run the debugger, create and delete folders, import source definitions
Create and delete folders, view object dependencies, import source definitions
Create and delete folders, create and edit mappings, create target tables
Which of the following is not a character function
LTRIM
SUBSTR
CONCAT
TRUNC
Which of the following is not a task in Workflow Manager
Email
Session
Workflow
Timer
Choose the correct option - Transformations which have only Input/Output ports
Expression
Router
Lookup
Aggregator
When would you use Joiner transformation
If you want to join two tables in same database
If the Order By clause needs to be changed
If you want to join two tables on different Oracle databases
If you want to join table and flat file
Which of the following is/are an Active transformation
Sorter
Connected Lookup
Unconnected Lookup
How many sources can be joined using Joiner transformation
1
2
3
Unlimited
Which are the different Lookup cache types
Persistent
Dynamic
Static
All of the above
Which transformation is used to read data from Cobol files?
Normalizer
Source Qualifier
Source Definition
Any transformation