Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7289 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravindra.15aug
In RDBMS we can write sql queary in Source qualifer by
using rowid, in sorter by using select distinct option, In
aggregator by using groupby, in Rank by using groupby.
In FF level also we can do except sql queary in source
qualifier.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / akash
In addition to the above answers I will add one more option.
We can use expression to check whether a record is
repeating or not and set an output port as flag. For first
occurence of any record this flag is 1. Use router after
this with condition "i_FLAG = 1". This output will give
only unique records. Default output will give only
duplicate records.
Also we can use a filter after the above expression with
the condition "i_FLAG = 1"
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / priyank
For FF, place an Aggregator transformation, do a group by
on all the columns, it will remove the duplicates from the
flat file.
In Oracle, use distinct in SQ sql override to remove the
duplicates.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is fact table? Explain the different kinds of facts.
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
Different sorts of metadata that stores in the storage facility?
What are multi-group transformations?
what are the settiings that u use to cofigure the joiner transformation?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is informatica etl tool?
How is Data Models Used in Practice?
Define informatica repository?
In development project what is the process to follow for an etl developer from day1
Teradata 
