Answer Posted / srinivas
1.Filter will removes unwanted data based on a filter
condition,if we want use multiple filter conditions using
filter it is not possible,so we have another option i.e router.
2.Router:advantage is one input can be passed and based
on filter conditions output will be get,here matched
condition and un-matched condition records can be get
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the types of data warehouses?
Explain joiner transformation in informatica
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How would you copy the content of one repository to another repository?
What will be the approach?
What is a pre-defined event and user-defined event?
How to do the error handling of if ur source is flatfiles?
How to implement security measures using repository manager?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How can we remove the duplicates from flat file source?
which one is better performance wise joiner or look up
Difference between Target-based loading and constraint-based loading?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM