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
- 4296 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 is the need of etl tools?
In update strategy target table or flat file which gives more performance ? why?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
What is difference macros and prompts?
In a concurrent batch if a session fails, can you start again from that session
Hi experts, can anyone tell how much we use plsql in real time
Mapplets can you use an active transformation in a mapplet,
what is datamart
Can we call a stored procedure from a unix script which is run using command task
Mention few advantages of router transformation over filter transformation.
what is informatica metadata?
Explain grouped cross tab?
Teradata 
