Source-1
No name
1 satish
2 karthik
3 swathi
4 keerthi
Source-2
No name
1 satish
2 karthik
5 santhose
6 vasu
Target
3 swathi
4 keerthi
5 santhose
6 vasu here i want non matching
Records i want how to achieve that
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 11 Yes | 3 No |
Answer / davankumar
ur qus is diffrent but ans is...u r ans non_duplicate
records into taget.
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
Differentiate between sessions and batches?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
can u any challenge your project?
A session S_MAP1 is in Repository A. While running the session error message has displayed
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
Without using any transformations how u can load the data into target?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What are the new features of informatica 9.x at the developer level?
Performance tuning( what you did in performance tuning)
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
What are the Differences between static cache and dynamic cache?