How do you create single lookup transformation using
multiple tables?
Answer Posted / koti
Re: How do you create single lookup transformation using
multiple tables?
Answer
# 1 Lookup transformation: Based upon one/more keys the
data is
retreived from one/more tables.
create a single lookup transformation by Joining the
multiple tables, having connected the keys defined in
lookup tranformation.
Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Which means the first record should come as last record and last record should come as first record and load into the target file?
write a query to retrieve the latest records from the table sorted by version(scd)
Enlist the advantages of informatica.
what is SDLC way of code development?
What is fact table? Explain the different kinds of facts.
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 joiner transformation?
generate date / time dimension in informatica
Describe data concatenation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Define enterprise data warehousing?
What are the static cache and dynamic cache in informatica?
How we can use union transformation?
How we can create indexes after completing the load process?