What are the Differences between connected and unconnected
lookup?
Answer Posted / giri
Connected Lookup Unconnected Lookup
---------------- -------------------
1.With Pipeline Without Pipeline
2.Static and dynamic Static cache only
cache only
3.Return Multiple port Return Single Port
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
What is the use of transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How are the sources and targets definitions imported in informatica designer?
Explain joiner transformation in informatica
What are ETL Tools?
Enlist few areas or real-time situations where informatica is required.
Explain lookup transformation source types in informatica
What is different between the data warehouse and data mart?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How do you migrate data from one environment to another?
What will be the approach?
How to create the source and target database connections in server manager?
What are the different ways to implement parallel processing in informatica?
What is standalone command task?
State the differences between sql override and lookup override?