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
- 4015 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 |
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
what is informatica metadata?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
how can we use sorter transformation in joins?
need for registering a repository server
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
How to improve the session performance in informatica?
What are the types of data that passes between informatica server and stored procedure?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
tell me 7.x and 8.x diferrencess(but not transformations)
What is option by which we can run all the sessions in a batch simultaneously?
difference between stop and abort
Teradata 
