Why we use lookup transformations?
Answer / guest
we use lookup transformation to lookup data in a relational
table ,view or synonym.and by using lookup transformation
we can perform the following jobs
-to get the related value
-to perform the calculations
-to update the slowy changing dimentions
| Is This Answer Correct ? | 3 Yes | 1 No |
How we can confirm all mappings in the repository simultaneously?
what is the diff b/w union and joiner and lookup?
What are the types of caches in lookup? Explain them.
what are surrogate keys?
On which transformations you created partitions in your project?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
when we dont use aggregator in mapping ?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
What is persistent lookup cache?
what is the command to get the list of files in a directory in unix?