Answer / venkatesh.malneni

here as the source meta data is same we can use UNION
t/r,after that i use AGGRIGATOR t/r in that i will count(no),
after that i will keep the filter t/r in that the condition
is count=0.then connect to the target
the result is as u want
the flow is as fallows

src--->sq--->union--->agg---->filter---->trg

Answer / davankumar

ur qus is diffrent but ans is...u r ans non_duplicate
records into taget.

Answer / ganga

Hi Davankumar,


once find the sources1 & 2 here both tables structures same
but some records are diff so i wanna find which columns are
diff

both tables contain 1,2 records but some records are diff
means 3,4,5,6 how to retrieve these to your target in
informatica level

Answer / lokeah

SRC---union--agg---filter---tr
Here two SRC got same data typs n table structure so we can merge dem both
In agrr check group by to name col and add one extra col and named it cnt and condition is count(name) and pass prts to filter in filer write condition
Cnt=1....den we can get required op

Answer / kumarapillaietl@gmail.com

Create union tr , send all ports from two sources ,create sorter tr after union sort port asc in column no.
And send this ports into new exp tr here create 3 variable port one output port.
V_curr_no=id------>no.
V_count=iif(v_curr_no=v_pre_no,v_count+1,1)
V_pre_no=I'd
O_count=v_count
After done exp tr
Pass all ports from exp to filter
Condition like o_count=1
Get all non_match records .then pass into tgt .

Happy thank yoy

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

How can you generate reports in informatica?

0 Answers  

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

what is INFORMATICA TESTING process

0 Answers  

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

What are the join types in joiner transformation?

1 Answers   Informatica,

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

what is data driven?

5 Answers   TCS, Wipro,

disable caching in a lookup transformation?

1 Answers