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
- 4448 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
Write the different tools in the workflow manager?
What is workflow manager?
Explain sql transformation in script mode examples in informatica
What is pmcmd command?
Enlist the advantages of informatica.
Write the unconnected lookup syntax and how to return more than one column.
what is degenerated dimension?
What is an active transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain the different kinds of facts.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is parallel processing in informatica?
What is the need of etl tools?
what is size of u r database?
Write the program through which the records can be updated?
