Interested to Buy Any Domain ? << Click Here >> for more details...
What are active transformations? Name them.
- 1 Answers
- 2523 Views
- I also Faced
- E-Mail Answers
Answer / mahi
Active transformation change the rows that pass through the mapping.
aggregator,filter,sorter,router,source qualifier,transaction control ete.. are active transformations in informatica.
| Is This Answer Correct ? | 0 Yes | 0 No |
how many data models u have done in informatica project?
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.
Is there any target staging area in informatica not staging area
Under what conditions selecting sorted input in aggregator will still not boost session performance?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
Explain the etl program with few examples.
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
What is mapping debugger?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
difference between repository database and repository service?
what is mapping override?
Teradata 
