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
- 3703 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 |
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What is fact table? Explain the different kinds of facts.
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
What is mapplet in informatica?
explain about session partitions ?
What is diff joiner and lookup
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
My source table having some records ,i want load 1st record and last record into one target?
How can you define a transformation? What are different types of transformations in Informatica?
how the server recognises , if the session fails after loading the 100 records in to the target
difference between informatica 8.1.1 and 8.6
What are the designer tools for creating tranformations?
Teradata 
