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
- 4372 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
how we can load rejected record's at run time?(not through bad files)
How to generate sequence numbers?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Which files are created during the session rums by informatics server?
Explain dynamic target flat file name generation in informatica
What are the tuning techniques you applied during your last project
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How does a sorter cache works?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the data movement modes in informatica?
Explain sql transformation in script mode examples in informatica
What is the Rank index port in Rank transformation?
How we can create indexes after completing the load process?
How to create Target definition for flat files?
Briefly describe lookup transformation?
