Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
lookup transformation with screenshots
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What differs when we choose the sorted input for aggregator transformation?
What is the use of code page?
what are 3 tech challenges/ common issues you face?
In development project what is the process to follow for an etl developer from day1
Write the prerequisite tasks to achieve the session partition?
What is the difference between stop and abort in informatica
How to elaborate tracing level?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How you can differentiate between connected lookup and unconnected lookup?
What is depict expression change?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is dimensional table?
What will be the approach?
