Which of the following task can be made reusable?
Session
Command
Email
All of the above
Which of the following port is used only in unconnected look up not in connected look up?
Input
Variable
Return
Output
We can use the joiner in case of?
Joining two flat files
To join two table from different data bases
To join flat file and relational table
In which of the transformation we can discard duplicate data?
Source qualifier, Sorter
Sorter, Joiner
Joiner, Expression
Which is not true regarding unconnected lookup?
It does not contain return port
Executed for ever record passed
Works only when lookup function is called
All of above
What does a power center domain require,at a minimum?
Repository Service and Repository Database
Repository Service and Administraive Console
Repository Service and Client Application
Repository Service and Integration Services.
Why is it best to use shortcuts to a common directory for source and target definition objects?
Enforces single –name standard for Sources and Targets.
Shortcuts work more efficiently with databases.
Developers should never create Source and Targets objects on their own.
Makes migration easier and more efficient.
Null value in SQL represent?
An empty String
Zero
NULL is the value used to represent an unknown piece of data
Numeric
A employee table contain below values empno empname deptno salary 1 aaa 10 30000 2 bbb 20 25000 3 ccc 10 Null 4 ddd Null 35000 select count(deptno) from employee?
1
3
2
4
A employee table contain below values empno empname deptno salary 1 aaa 10 30000 2 bbb 20 25000 3 ccc 10 Null 4 ddd Null 35000 Select avg(salary) from employee?
0
30000
22500
35000