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
- 3822 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 DR strategy for Informatica project?
What is target load order?
What are the components of the workflow manager?
How can we use batches?
Is it possible to use a client with different version than that of its Informatica server?
How to do the error handling of if ur source is flatfiles?
How many ways are there to create ports?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Explain the shared cache and re-cache?
Explain scd type 3 through mapping.
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain the aggregator transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
What is option by which we can run all the sessions in a batch simultaneously?
What are the prerequisite tasks to achieve the session partition?
