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
Answers were Sorted based on User's Feedback
Answer / shridhar kasat
For Unique and Duplicate , we can go for same flow :
by this column and find count also)--> then use joiner (use
the column from Source qualifier and join the data from
Aggregator as source qualifier.col=aggregator.col) -->
Router (insert into t1 for count>1 and for count=1 insert
into t2). t1 is for duplicate records and it will cintain
1,1,3,3 and t2 will have 2,4.
Records in Source Q :
The records after agregator will look like this :
Records after Joiner : source q.col=aggregator.col
These records will flow in router and we define two groups;
one for count>1 (for duplicates record) and second for
count=1 ( for unique record)
Hope this answer suffice your requirements.
|Is This Answer Correct ?||23 Yes||0 No|
Answer / suman chattopadhyay
Part 1 of your answer is not correct. If you use distinct
option in sorter you will get all the distinct values even
for the duplicate. i.e if the values are 1,1,2,3,3,4, you
will get 1,2,3,4 in target.
Part 2 of your answer will do all the trick for duplicate
and unique ones. If you use group by and count the number
of occurences you will get 1 as the count for unique values
and more than one as count for duplicate values. Pass those
records with count 1 to 1 target and the other to the 2nd
Hope this helps.
|Is This Answer Correct ?||10 Yes||1 No|
Answer / sanju_yu
source> dynamic lookup>router,2 conditions in router
1. condition if column_lkp port is null then insert into
2. condtion if COLumn_lkp port is not null then insert into
Plz let me know if am wrong
|Is This Answer Correct ?||7 Yes||4 No|
Answer / shirish
1.For unique: Source-->SrcQualifier--> sorter (use distinct
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|
Answer / rahul
will this logic work when we are loading for the 1st time
|Is This Answer Correct ?||0 Yes||1 No|
I have 1200 records how can u send it in aggregator with good performance issues?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain the aggregator transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the Differences between static cache and dynamic cache?
what type of transformation is not supported by mapplets?
What are the different lookup cache(s)?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
what is the difference between informatica6.1 and infomatica7.1
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is sequence generator transformation in informatica?