Answer / kesava reddy

Using Source Qualifier Trnsformation ,
Explantion:
1.Take 2 Source Qualifier Transformations,and
2.One sq ports connect to Target(Unique Target) then Write
a SQL Query (sqlOverride) ,
SELECT DISTINCT EMPNO,ENAME
FROM EMP;
3.TAKE ANOTHER SQ AND CONNECT TO ALL PORTS TO TARGET,THEN
DEVELOP THE SQLOVERRIDE,
SELECT * FROM EMP WHERE ROWID IN(SELECT ROWID FROM EMP
MINUS
SELECT MAX(ROWID) FROM EMP
GROUP BY EMPNO,ENAME)

Answer / shiva

s-->sq-->agg-->rtr-->tgt1
'--> tgt2

in aggr take two ports count(*)=1
count(*)>1 take group by on column


send this to rtr(create 2 groups in rtr)

Answer / mohan

Here is the minor modification on Answer #6 posted by me,
SQ-->Sorter-->Expression-->Router-->Targets

Sorter Transformation: Sort by key column(EMP_ID)
Expression Transformation:
V_Match(variable port) =IIF(EMPNO=V_OLD_EMPNO,1,0)
V_OLD_EMPNO(Variable)= EMP_ID
O_EMPNO(output)= V_MATCH

Router Transformation:
create two groups under groups tab,
Original : O_EMPNO=0
Duplicates: o_EMPNO=1 

Answer / naresh araveti

source> dynamic lookup>router,2 conditions 1. condition
if column_lkp port is null then insert into target1(unqie)
2. condtion if COLumn_lkp port is not null then insert into
target2(duplicates)

Answer / ram mohan reddy

we can do this process by 2 ways ....
1)by dynamic lookup option in lookup(new lookup row) we can
load duplicate rows in one target table and unique rows in
one target table
do to this we need to have router transformation (add to
group ports one is for unique(new lookup row=1) and other is
for duplicate(new lookup row =2))after the lookup trans.
2)we can perform this by aggregator transformation using
coutnt(*) >1 for duplicate rows .here also we need to use
router transformion.

Answer / venkat

S->S.Q->Aggr->Rtr->T1
->T2


Where Aggr take group by option
Rtr group1 condition reccount>1..........>T1
Rtr default group to....................>T2


T1 records are unic records
T2 records are duplicate records

Answer / mohan

SQ-->Sorter-->Expression-->Router-->TGT

Sorter: Sort by key column(EMP_ID)
Expression:
V_OLD_EMPNO EMP_ID
V_Match IIF(EMPNO=V_OLD_EMPNO,1,0)
O_EMPNO V_MATCH

Router:
create two groups under groups tab,
Original : O_EMPNO=0
Duplicates: o_EMPNO=1

Answer / vaas

Hi All,

One tbl has duplicate values means it does not has PK.In
this case can we use dynamic lookup.

Pl let me know, on vaas31@yahoo.in

Answer / dwhlabs

1> using dynamiclookup concept
2> using variable concept

First solution

source > sorter >dynamic lookup > filter > Target1 and
Target2

for more abt informatica mappings ... www.dwhlabs.in

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

What is the difference between IN and Exists in Oracle?

3 Answers   Deloitte,

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

0 Answers   CTS,

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

1 Answers   Puma,

Explain the different kinds of facts.

0 Answers  

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,