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

Without using any transformations how u can load the data into target?

15 Answers   IBM,

Can you copy the session to a different folder or repository?

1 Answers  

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

tell me the push down optimization

2 Answers   Wipro,

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

Repository user profiles

0 Answers  

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

What do you mean by enterprise data warehousing?

0 Answers  

What is decode in static cache?

0 Answers  

What is the meaning of decode in informatica?

0 Answers  

How to join three sources using joiner?

0 Answers  

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers