How to extract original records at one target & Duplicate
records at one target?

Answer Posted / sunil

Its not very clear by using expression transformation.Can
any one eloberate. I am creating one variable port VAR_EMPNO
in exp and giving value as EMPNO.Created one output port
EMPVAR_OP with cond : IFF(EMPNO = VAR_EMPNO,1,0) Based on
this I am filtering and redirecting to two targets but its
not working, is the expression fine over here?

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6640


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1981


what is $$$$?

1822


How many dimensions are there in informatica?

719


What are different types of transformations available in informatica?

670






Sequence generator, when you move from develoment to production how will you reset

1527


What is meant by a domain?

744


Explain the mapping variable usage example in informatica

725


What are connected or unconnected transformations?

721


What are the different transaction levels available in transaction control transformation?

754


Do you find any difficulty while working with flat files as source and target?

769


How can a transformation be made reusable?

749


How to create a non-reusable instance of reusable transformations?

784


define galaxy repository in informatica

1825


What do you mean by filter transformation?

644