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
- 4290 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 are the types of facts with Examples?
Design a mapping to load the cumulative sum of salaries of employees into target table?
explain about unit testing? in real time?
Which transformation should u need while using the cobol sources as source defintions?
Explain the features of connected and unconnected lookup.
what is the size of u r project? and what is the size of source file?
where actually the usage of push down optimization happens...
what are the row and column separations in Flat Files
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
What is deployemnt groups, Lables, query and dynamic deployment group.
diffrence between command task and control task
Teradata 
