What are the performance considerations when working with aggregator transformation?
To import the flat file definition into the designer where should the flat file be placed?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
In development project what is the process to follow for an etl developer from day1
What could be the possible resons of locks by user?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
Why you use repository connectivity?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
server hot-ws270 is connect to Repository B. What does it mean?
How to run a session, which contains mapplet?
What is predefined event?
Explain the difference between mapping parameter and mapping variable?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output