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
- 7901 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain why we use partitioning the session in informatica?
Define the various join types of joiner transformation?
While migrating the data from one environment to another environment how would you manage the connections?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
is it possible to index the data in cache of lkp transformation ?
Whats there in global repository
What is DR strategy for Informatica project?
Slowly changing dimensions, types and where will you use them
What are the main issues while working with flat files as source and as targets ?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Briefly explain the aggregator transformation?
Explain the code page compatibility?
What is Session and Batches?
What is the different lookup cache(s)?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
