Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique re..

Answer / shridhar kasat

For Unique and Duplicate , we can go for same flow :

Source-->SrcQualifier-->Aggregator(group
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 :
col
1,1,2,3,3,4

The records after agregator will look like this :
col count
1 2
2 1
3 2
4 1

Records after Joiner : source q.col=aggregator.col
col count
1 2
1 2
2 1
3 2
3 2
4 1

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.

Regards
Shri

Is This Answer Correct ?    23 Yes 0 No

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique re..

Answer / suman chattopadhyay

Shirish,

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
target.

Hope this helps.

Suman

Is This Answer Correct ?    10 Yes 1 No

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique re..

Answer / sanju_yu

source> dynamic lookup>router,2 conditions in router
1. condition if column_lkp port is null then insert into
target1(unqie)
2. condtion if COLumn_lkp port is not null then insert into
target2(duplicates

Plz let me know if am wrong

Sanjay

Is This Answer Correct ?    7 Yes 4 No

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique re..

Answer / 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

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique re..

Answer / dinesh

can u give prepare solution

Is This Answer Correct ?    0 Yes 1 No

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique re..

Answer / rahul

hi sanjay,

will this logic work when we are loading for the 1st time

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More Informatica Interview Questions

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  


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?

7 Answers   IBM, TCS,


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  


Explain the aggregator transformation?

0 Answers  


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

0 Answers  






What are the Differences between static cache and dynamic cache?

1 Answers  


what type of transformation is not supported by mapplets?

4 Answers   CTS,


What are the different lookup cache(s)?

0 Answers  


In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


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.

0 Answers  


What is sequence generator transformation in informatica?

0 Answers  






Categories