Interested to Buy Any Domain ? << Click Here >> for more details...
Why use the lookup transformation ?
- 2 Answers
- 6557 Views
- Informatica, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rekha
1. GET A REALTED VALUE
2.UPDATE SLOWLY CHANGING DIMENSION
3.PERFORM CALCULATIONS
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / swetha
To perform the following tasks.
Get a related value. For example, if your source table
includes employee ID, but you want to include the employee
name in your target table to make your summary data easier
to read. Perform a calculation. Many normalized tables
include values used in a calculation, such as gross sales
per invoice or sales tax, but not the calculated value (such
as net sales). Update slowly changing dimension tables. You
can use a Lookup transformation to determine whether records
already exist in the target.
| Is This Answer Correct ? | 0 Yes | 1 No |
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
What is a command that used to run a batch?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
Explain about the concept of mapping parameters and variables ?
Where is metadata stored?
How big was your fact table
what is the significance of newlookup port in dynamic look up
What are the data movement modes in informatcia?
How can informatica be used for an organization?
How can you complete unrcoverable sessions?
What is union transformation in informatica?
What is the scenario which compels informatica server to reject files?
Teradata 
