Interested to Buy Any Domain ? << Click Here >> for more details...
Hi
If i had source like unique & duplicate records like 1,1,2,3,3,4
then i want load unique records in one target like 2,4 and i want
load duplicate records like 1,1,3,3 then can any body please send
me what is th scnario. my mail i
shek.inform@gmail.com
- 6 Answers
- 19207 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
Answer Posted / shirish
1.For unique: Source-->SrcQualifier--> sorter (use distinct
option)--> Target
2. For duplicate : Source-->SrcQualifier-->Aggregator(group
by this column and find count also)-->filter(use count
greater than 1 )--> left outer join with source qualifier --
> target 2.
Hope i am clear.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
What is a rank transform?
differences between service based and product based?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain what are the different types of transformation available in informatica.
How many ways are there to create ports?
What is parallel processing in informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to go to the older version for a mapping?
Explain the different kinds of facts.
What is aggregator transformation in informatica?
How to use procedural logic inside infromatica?
What is meant by pre and post session shell command?
What is standalone command task?
