-
-
-
Why we use stored procedure transformation?
For populating and maintaining data bases.
-
Differences between connected and unconnected lookup?
Connected lookupUnconnected lookup Receives input values diectly from the pipe line.Receives input values from the result of a lkp expression in a another transformation.U can use a dynamic or static cache U can use a static cache.Cache includes all lookup columns used in the mapingCache includes all lookup out put ports in the lookup condition and the lookup/return port. Support user defined...
-
What r the diffrence between joiner transformation and source qualifier transformation?
U can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. U need matching keys to join two relational sources in source qualifier transformation.Where as u doesn’t need matching keys to join two sources. Two relational sources should come from same datasource in sourcequalifier.U can join relatinal sources which r coming from diffrent...
-
How can U improve session performance in aggregator transformation?
Use sorted input.
-
Can U use the maping parameters or variables created in one maping into another maping?
NO. We can use mapping parameters or variables in any transformation of the same maping or mapplet in which U have created maping parameters or variables.
-
What r the unsupported repository objects for a mapplet?
COBOL source definition Joiner transformations Normalizer transformations Non reusable sequence generator transformations. Pre or post session stored procedures Target defintions Power mart 3.5 style Look Up functions XML source definitions IBM MQ source defintions