when should one create lookup transformation ?
Answers were Sorted based on User's Feedback
Answer / kaki
Look up transformation is used for looking up a value from
OLAP table within a mapping before populating it. For
example, I have empid and I want to get emp name to use in
the next transformation, I would search for it in a look up
table which has the emp name by giving input as emp id.
Is This Answer Correct ? | 1 Yes | 0 No |
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
what is the difference between cubes and package in cognos
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
where is the cache (lookup, index) created and how can you see it.
what is pmrep command?
What is tracing level?
what happens if the info.server doesn't find the session parameter in the parameter file?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
how do u set partition points in the mapping?
What is cube grouping?
What are the various tools used in etl?
How to Check the source record count from traget table.