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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain about cumulative Sum or moving sum?
What is the difference between writing a joiner query in ANSI style and THETA style?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is data movement mode in Informatica and difference between them?
How does a sorter cache works?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain load alternative records / rows into multiple targets - informatica
Briefly describe lookup transformation?
What is a repository? And how to add it in an informatica client?
explain one complex mapping with logic? sales project?
what is index?how it can work in informatica
can anyone suggest best free Talend data integration training online