Comment on significance of oracle 9i in informatica when
compared to oracle 8 or 8i?
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 ?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
Discuss the advantages & Disadvantages of star & snowflake schema?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the types of schemas we have in data warehouse and what are the difference between them?
How does a sorter cache works?
What are the types of maping wizards that r to be provided in Informatica?
Is it possible to use a client with different version than that of its Informatica server?
Which is better performance wise database or file?How?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
What is a shortcut and copy in Informatica and how two are different with each other?