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
- 4313 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 informatics server which files are created during the session rums?
How do you handle two sessions in Informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are some examples of informatica etl programs?
How to convert multiple rows to single row (multiple columns) in informatica
What is meant by incremental aggregation?
How is union transformation utilized?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
what is informatica metadata?
Is stop and abort are same in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Plz can any one say me how to get the informatica certification materials and dumps
What are the uses of etl tools?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Make a note of the quantity vaults made in informatica?
