Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 8053 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
Explain in detail about scd type 1 through mapping.
What do you mean by enterprise data warehousing?
What are the databases that informatica can connect to windows?
Explain lookup transformation is active in informatica
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
How can we remove the duplicates from flat file source?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Make a note of the quantity vaults made in informatica?
What is meant by a domain?
Slowly changing dimensions, types and where will you use them
What is exclusive and normal mode for repository services?
Partition, what happens if the specified key range is shorter and longer
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
