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
- 3700 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
In how many ways we can create ports?
What is data transformation manager process?
Explain sql transformation in script mode examples in informatica
What is Cognos script editor?
What is native users?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Differentiate between Load Manager and DTM?
What is an active transformation?
Explain the tuning lookup transformation - informatica
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How many number of sessions can one group in batches?
How to update a particular record in target with out running whole workflow?
what is mean by complex business rule ?
What are the new features of informatica 9.x developer?
How does a rank transform differ from aggregator transform functions max and min?
