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
- 4386 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
I have a flat file, want to reverse the contents of the flat file
What is union transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Does an informatica transformation support only aggregate expressions?
How do you load first and last records into target table?
What is target designer and target load order?
How we can create indexes after completing the load process?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Differentiate between joiner and lookup transformation?
How to generate sequence numbers?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the tasks that source qualifier perform?
How do you load only null records into target? Explain through mapping flow.
