Eliminating of duplicate records without using dynamic lookups
Answers were Sorted based on User's Feedback
Answer / pooja ahmed
1. you can you use sorter transformation .... in that you
select distinct option
2. use agg trans .... in that go for group by
usi8ng above metyhod you can remove duplicate rec...
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / bsgsr
duplicate records can be eliminated the following ways:
1) by using select distinct option
2) by over riding sql with group by port on the column
which gets duplicate values ( P_key column)
3) by connecting the source to an expression transformation
and flagging the duplicate records to another target by
writing an expression in the exp editor
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / raghav
with out distinct we can do it in 3 possible ways.
1. Using Group by function which will act like a distinct in
TD13.0 database
2. using SET table concept, like first we create the multi
set table and insert the duplicate rows into them and then
create the set table and use the insertselcet concept, in
this case only distinct rows will be inserted.
3. use rowid, derived table or sub query concept then we can
do this
Is This Answer Correct ? | 1 Yes | 0 No |
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
what happens if the info.server doesn't find the session parameter in the parameter file?
what are the parts of Informatica server ?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
State the differences between shortcut and reusable transformation
What are dimensions?
what is meant by drill through?(Mascot)
Can u access a repository created in previous version of Informatica?
Difference between flat files and relational sources?
what do u do when DB time takes more?in sap bi
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?