Answer Posted / vishnu
My answer would be like in the case of filter t/r if the c ondition is not mentioned then the default condition is true i.e., all the records from the source r moved to the target in this situation filter t/r acts as passive.
suppose in aggregator t/r if we r not mentioned any group by port then last record will be displayed in this situation it acts as active.So not all active t/rs are passive
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is workflow? What are the components of the workflow manager?
Why is sorter an active transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Differentiate between sessions and batches?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What do you mean by enterprise data warehousing?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Where do we use mapping variables in informatica?
What is a grid in Informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is blocking transformation?
What is a snowflake schema?
Briefly describe lookup transformation?