What are 2 modes of data movement in Informatica Server?
Answer Posted / arpita
Normal Mode and Bulk Mode
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
How do you convert single row from source into three rows into target?
What is meant by target load plan?
Informatica settings are available in which file?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the difference between a repository server and a powerhouse?
Clarify the aggregator change?
Tell me about MD5 functions in informatica
What are the different types of repositories created using informatica?
Differentiate between source qualifier and filter transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is a sequence generator transformation?
Explain the tuning lookup transformation - informatica
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?