What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
601How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
1004How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
630I 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.
630Post New Informatica Questions
What are the tasks that source qualifier perform?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the difference between Active and Passive transformation?
How can we improve session performance in aggregator transformation?
what is the -ve test case in your project.
Explain joiner transformation in informatica
Explain the different dimensions.
What are the designer tools for creating transformations?
What is the meaning of decode in informatica?
What is the use of an aggregator cache file?
How to handle decimal places while importing a flatfile into informatica?
What can we do to improve the performance of informatica aggregator transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How do you take back up of repository?