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
- 19035 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
where to store informatica rejected data? How to extract the informatica rejected data?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What does reusable transformation mean?
Can we get 1st record through Informatica(without sequence number).
Is it possible to use a client with different version than that of its Informatica server?
What do you mean by channel change?
Please let me know how to make encryption and decryption with example?
Describe the impact of several join conditions and join order in a joiner transformation?
Can you use flat files in Mapplets.
How to load last n records of file into target table - informatica
What is an unconnected transformation?
What are the types of lookup transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How to handle decimal places while importing a flatfile into informatica?
