What is predefined event?
What is the use of an aggregator cache file?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
How to eliminate 1st and last rows from the source and load the inbetween rows.
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
how do u fnd the duplicate rows and how to delete the duplicate rows?
What are the mapings that we use for slowly changing dimension table?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are reusable transformations in how many ways we can create them?
Explain in detail about scd type 1 through mapping.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?