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
what is index?how it can work in informatica
How do you use reject loader.
What do you understand by term role-playing dimension?
What is session task and command task?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the different types of olap? Give an example?
What is joiner transformation in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the issues you have faced in your project? How did you overcome those issues?
How do you load unique records into one target table and duplicate records into a different target table?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
permutations of mapplet
Explain the difference between a data warehouse and a data mart?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain sql transformation in script mode examples in informatica