Question { 8819 }

What is data merging,data cleansing,sampling?

Answer

Data Merging: It is a process of combning Non-Similar
structures or Similar structure data into Target Warehouse
system.
To combine Non Similar we can use Joins Concept,For
Similar We can use Union Concept

Data Cleansing:It is a process of converting Non Unique
data format of the source system into unique data format of
Target Warehouse system.

I dont Know definion for Data Sampling..can anyone plz give
the answer...

Question { 23671 }

What is difference between a connected look up and
unconnected look up?

Answer

1) A connected Lookup transformation receives input values
directly from another transformation in the pipeline.

An unconnected Lookup transformation receives input values
from the result of a :LKP expression in another
transformation. You can call the Lookup transformation more
than once in a mapping.

2)IN connected The Integration Service passes return values
from the query to the next transformation.

In Unconnected The Integration Service returns one value
into the return port of the Lookup transformation.

3)Connected uses Dynamic or Static Cache,whereas
Unconnected use a static cache

Question { L&T, 30472 }

Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?

Answer

its invalid..we shouldnot connect active n passive together.

Question { L&T, 30472 }

Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?

Answer

Sorry..we can connect an active with an Passive
transformation..
for example when we create Mappings for SCD2 ..we connect
Filter with Expression..where Filter is Active And
Expression is Passive.