What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
1 1859What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
1149I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
1062Post New Informatica Questions
lookup transformation with screenshots
What are the designer tools for creating transformations?
What is meant by incremental aggregation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a shortcut and copy in Informatica and how two are different with each other?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the need for an etl tool?
What is dimensional table?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the different types of repositories created using informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How do you take back up of repository?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??