Answer / sks

Hi,
Yes you can do it by using Expression transformation as
well. Infact, by using 2 SQ (source qualifier) and using
sql queries (as I explained earlier), you can perform the
required task on relational tables only (but not on flat
files etc).
In the case of flat files as source, you will need to use
Expression transformation. But you also need to use sorter
before expression (otherwise record flag will change for
every incoming record & duplicates won't be traced). The
sequence of transformations will be as follows -

Source -> SQ -> Sorter ->Expression ->Router(or 2 filters) -
>Targets

Answer / shankar

First Pipeline:

SQ--Sort---Tgt1

Second Pipeline:

SQ--Lkp on Tgt1--If The value is matched from both the table
send it to Tgt2.

Use target load plan while u run the session...

Answer / amrita

can you tell me scèneario.

Answer / krishnakanth.ch

yes... add a new column in the sql override by calculating
the count(*) to get how many times the record is repeating.
Using Router we can seperate them into two different
targets.

Answer / sujan reddy

hi

Answer / davan

sq-->sort--exp--riuder--tg1--tg2
In exp V_flag=iif(empno=p_empno,v_flag+1,1)--variable port
p_empno=empno--variable port
0_flag=v_flag--output port
In rouder o_flag>1 one target,default one target

Answer / kumar

The scenario's.. i want, duplicate records from a table to a
target.. n remaining records to b on another target...

Answer / 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?

Answer / vineeth

using connected lookup

Answer / sks

Hi,
If I understand your question correctly, then it is like-
How to send original (distinct) records to one target
(let's say TA) and duplicates to another target (let's say
TB).
It can simply be done as follows -
In your mapping, take the source table containing whole
records (duplicates as well). Now, take 2 source qualifier
(SQ) transformations. The first SQ should
contain 'Distinct' sql query (hope you know that) and the
output ports should go to TA table.
The second SQ should contain the following sql stmt (which
filters only the duplicate records) -
-------------------------------------------
SELECT empno, ename, job, mgr, hiredate, sal, comm, deptno
FROM (SELECT empno, ename, job, mgr, hiredate, sal, comm,
deptno, ROW_NUMBER() OVER (PARTITION BY empno ORDER BY
EMPNO) rn FROM s_assign_1_emp)
WHERE rn > 1
-------------------------------------------
I am using emp table example (hope you can understand it).
Now, the output ports of the seecond SQ should go to TB
table.
This is the simplest way of doing it. Hope it will help.

If you feel any issue, please let me know at
shrikant_rps@yahoo.com

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

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

0 Answers   IBM,

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

how to duplicates from expression transformation without using sorter before that

1 Answers  

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

can we generate reports in informatica ? How?

3 Answers