Interested to Buy Any Domain ? << Click Here >> for more details...
how to load the data in fact table..
using look up transformation how to view the second record.
usally look up shows matching record for only one value. if
i have same value its not displaying.
ex: problem i faced.
i have total, student no and name in table student
i used aggregation transformation to display max(total). i
have two same max values in total. when i look up the
student name and no for this max(total), its showing only
one name and no, its leaving the second one. how to rectify
it. plz tel me step by step or clearly.
- 1 Answers
- 4291 Views
- I also Faced
- E-Mail Answers
Answer Posted / preety
While creating lookup transformation , make the lookup as active. you will get all the matching records from the lookup table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is target load order?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Why do you use Mapping Parameter and mapping variable?
What do think which one is the better joiner or look up?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Why sorter is an active transformation?
If informatica has its scheduler why using third party scheduler?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to create a non-reusable instance of reusable transformations?
Explain the different lookup methods used in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
State the differences between sql override and lookup override?
How to elaborate tracing level?
