Can we use different lookup tranformations for a same
lookup table (lookup condition may or may not be same)with
different output ports? How the cache files will be
affected? Please clarify..
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Enlist the differences between database and data warehouse.
What is target update override
Implementation methodology
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
How to update a particular record in target with out running whole workflow?
Why we need XMLs?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
What are the different caches used in informatica?