in aggregator transformation we want to get middle record
how to implement, source containg empno,name sal,deptno,address
What are the rank caches?
What is flashback table ? Advance thanks
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
Differentiate between Load Manager and DTM?
where to store informatica rejected data?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the function of look up transformation?
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How can yoU create or import flat file definition in to the warehouse designer?