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
- 19343 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 roles and groups and benefits of using them?
What do think which one is the better joiner or look up?
How to load the data from people soft hrm to people soft erm using informatica?
What do you understand by SOA of Informatica?
what is informatica metadata?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How can we create index after completion of load process?
What happens when a session fails and you click on recover?
Suppose we do not group by on any ports of the aggregator what will be the output?
Explain the etl program with few examples.
Mention some types of transformation?
Explain the difference between a data warehouse and a data mart?
What is Index Caches size?
How can you validate all mappings in the repository simultaneously?
What is fact table? Explain the different kinds of facts.
