Comment on significance of oracle 9i in informatica when
compared to oracle 8 or 8i?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How will u pas the data with out debugger?
How to generate a single mapping for both the historical and incremental load.
Why we use partitioning the session in informatica?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
what is correlated query?
What are the designer tools for creating transformations?
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
Discuss the advantages & Disadvantages of star & snowflake schema?
what is the monster dimension plz give me one example