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
- 4311 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 diff b/w cached and unchaed look ups
What is joiner transformation?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
What are reusable transformations in how many ways we can create them?
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
what is normalization? explain 1st NF, 2nd NF, 3rd NF
What is meant by incremental aggregation?
how many types of dimensions are available in informatica?
How do you implement scheduling in Informatica?
what is metadata?
what is bitmap index? did u use it?and how to use it in informatica
Teradata 
