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
- 19543 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 is a code page?
Clarify the aggregator change?
What are the new features of Power Center 5.0?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How we can create indexes after completing the loan process?
explain abt ur project architecture?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is confirmed fact in dataware housing?
What does update strategy mean, and what are the different option of it?
What is meant by pre and post session shell command?
EXL informatica Questions
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Where is metadata stored?
Explain sessions and how many types of sessions are there?
How do you migrate data from one environment to another?
