Which of the following is true for delete?
Delete statement can be given without writing where clause.
We can delete two tables simultaneously
Both a & b
None of the above
How do you rename a table ?
alter table table_name rename to new_table_name;
RENAME table_name new_table_name;
Dropping the table and creating once again
None of the above.
Cache files contains
*.idx and *.bat
*.idx and *.dat
*.che and *.txt
*.dat and *.err
Name of the port created automatically while working with dynamic cache
NewLkpRow
NewRow
NewLookupRow
No ports were created
A Router transformation has the following types of groups
Input Group, Output Group
Input Group,Output Group, Default Group
Output Group, Default Group, User Defined Group
No groups were created
A Sorter Transformation is
Active Transformation
Passive Transformation
None
Both
A UNION Transformation is
A mapping is created with a flatfile Target. Options to change the flatfile delimiter
Session
Session/Mapping
Target Definition/Session
Not possible to change
What is the out put of Joiner Transformation, if we use Detail Outer Join
All the rows from master and detail table
Matching rows from detail table and all rows from master table
Matching rows from master table and all rows from detail table
Only matching from master and detail table
Informatica 8x is
Server Oriented Architecture
Service Oriented Architecture
Application Oriented Architecture
Web based Architecture