Answer Posted / sai suresh
2 . Look up data in relational able, view, or synonym,
Input a look up definition from any relational data base to
which both the informatica client and server can connect.
You can use multiple lookup transformations in mapping.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain incremental aggregation in informatica
How to generate sequence numbers?
What are the types of schemas we have in data warehouse.
what is the size of your data warehousing?
What is workflow? What are the components of the workflow manager?
whats the logic to load the lower level of granularity of data to fact table.
Explain target update override in informatica
what is informatica metadata?
Can informatica load heterogeneous targets from heterogeneous sources?
have u done any performance tuning? how u ll do?
Explain the code page compatibility?
What can we do to improve the performance of informatica aggregator transformation?
How can we update a record in the target table without using update strategy?