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
- 3825 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 |
What are data-driven sessions?
When will you use SQL override in a lookup transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
If I am having 6 flat files in data. How can you load the data at a time
how many data models u have done in informatica project?
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
How to delete first 3 rows & last 3 rows in target table in informatica
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
How to fix the etl bugs..Tell me the process?
what is the flat file partition and where have to specify it
need for registering a repository server
Teradata 
