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

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  

---

What is status code?

2 Answers  

---

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,

---

How do you set a varible in incremental aggregation

0 Answers  

---

what type of problem you faced insales project or insurance project

1 Answers   Sony,

---

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  

---

Explain constraint based loading in informatica

0 Answers   Informatica,

---

What are the different lookup cache(s)?

0 Answers  

---

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,

---

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---