Tag: technology

lkp , expression and rank transformations are Passive transformations

b. sorter ,sequence generator and Rank transformations are active transformations

c. Joiner,normalizer and union are Active transformations

d.unioin is a passive/active transformation

a.select insert, select update and do not select delete

b.treat source rows as data driven, select insert, select update as update and do not select delete

c.treat source rows as data driven, select insert, select update and do not select delete

d.treat source rows as data driven, select insert, select update,

a. iif(a=1,2,1)

b. iif(a=1,0,1)

c. iif(a=1,1,0)

d. iif(a=1,1,2)

a. source qualifier joins the heterogeneous sources

b. joiner transformations joins the heterogeneous sources

c.joiner transformation can only join homogeneous sources.

d. source qualifier can joins both heterogeneous and homogeneous sources

a. duplicate rows are sorted based on the case.

b. You can configure the Sorter transformation to treat output rows as distinct.

c. The Integration Service rejects duplicate rows compared during the sort operation.

d.none of the above

a. You can connect more than one group to a multiple input group transformation, except for Joiner transformations, when you connect each output group to a different input group.

b. You can connect more than one group to one target or a single input group transformation

c. You can connect multiple output ports in one group to multiple transformations or targets

d. You can connect one group to one transformation or target.

True

False

a.Both Filter and Router drops the falls condition records

b. Both Filter and Router will not drops the falls condition records

c.filter drops the falls condition records but router will pass through this records

d.Router drops the falls condition records but Filter will pass through this records

a. source qualifier transformation alone.

b. sorter and sequence generator.

c.source qualifier and expression transformation

d. sorter transformation alone

a.sorter,sequence generator

b.lookup,sorter,joiner

c.lookup,normalizer

d.joiner & union