While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?
Answer Posted / krish
flat file
bcz no connections needed no network busy etc;
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How to open an older version of an object in the workspace?
What are the different ways to implement parallel processing in informatica?
What are the differences between source qualifier and joiner transformation?
What is a snowflake schema?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is $$$$?
Describe expression transformation?
What is the advantage of informatica?
Could you explain what is enterprise data warehouse?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
If informatica has its scheduler why using third party scheduler?
What do you mean by channel change?
What is sorter transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
What are ETL Tools?