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
- 3961 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
What do you mean by filter transformation?
Why you use repository connectivity?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
How does the aggregator transformation handle null values?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
What is parameter file?
What are limitations of joiner transformation?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
draw informatica architecture 8.6 ?
What is joiner cache?
Teradata 
