What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?239
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?430
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.225
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.234
What is the function of look up transformation?
How union transformation is used?
In warehouses how many schemas are there?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What the difference is between a database, a data warehouse and a data mart?
Differentiate between joiner and lookup transformation?
Enlist the tasks for which source qualifier transformation is used.
How do you take back up of repository?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What if the source is a flat-file?
Mention a few design and development best practices for informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Quickly characterize reusable change?
How to create a non-reusable instance of reusable transformations?