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

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  

What is xml source qualifier transformation in informatica?

0 Answers  

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

What is the surrogate key?

0 Answers  

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

What is main use of mapplet?

0 Answers  

What is query panel?

1 Answers  

What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

What did you do in source pre load stored procedure

1 Answers  

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,