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 might one distinguish in the case of mapping is right or not without associating session?

0 Answers  

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

how to delete duplicate records by using filter transfermation?

3 Answers  

What is Code Page Compatibility?

1 Answers  

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,

What is the need of etl tools?

0 Answers  

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

Why is meant by direct and indirect loading options in sessions?

4 Answers  

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,

How can repository reports be accessed without sql or other transformations?

0 Answers