Informatica MCQs Set: 11
21. where do you store the
overflow data? In cache files
22.
what is the newly added tech in 6.1 other than 5.1? Transaction controller and Sorter
23.
alter sorts the data and takes the same time as before
sorting the data. Why?
agg trans having
nested agg
agg trans
contains incremental
data driven
24.if
stored procedure transformation is after joiner trans the target table is
imported_________
detail table
master table
detail or
master
25.
Already we have empid to add empname which transformation is used? : lookup
26.
sorter transformation cache size?
2000000
16000
0
8000000
27.which
decreases the performace
is nul
not null
IIF
decode
simple condition –I Guess
decode multi
condition
28.
which transformation using sorter?
aggregate
joiner
lookup
29.source
table does not having which ports?
i/p ports
o/p ports
variable port
meta data
extension
30.
in stored procedure in which mode checks the sufficient diskspace
preload source
post load
sourcce
preload target
post load
target
31.
where you check the validity?
in workflow
only
in designer
only
at runtime of database
in workflow
32.
how can you evaluate null values in the comparision
null values are not used in comparision
low/high
treated as null (Most comparisons between nulls and other values are by definition
neither true nor false, but unknown)
determined by
database
No comments