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
Answer Posted / 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 |
Post New Answer View All Answers
What is parallel processing in informatica?
tell me 5 session failure in real time how can you solve that in your project?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Clarify the aggregator change?
Briefly define a session task?
what is the hint? how to use it to reduce the query processing in program?
What is a predefined event?
Explain constraint based loading in informatica
How can you validate all mappings in the repository simultaneously?
Explain in detail about scd type 1 through mapping.
What is lookup change?
Explain what is informatica metadata and where is it stored?
What is data transformation manager process?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
During the running session, output files are created by informatica server. Enlist few of them.