Interested to Buy Any Domain ? << Click Here >> for more details...
how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 10950 Views
- Patni, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sujatha
in the sq data has to be order by key column..then in the
expression trans we have to create a variable port to hold
the previous records key value...and one more variable port
to compare with the current records key value...if the prev
and curr are equal then the 2nd variable value will
get 'Y',if not equal its value will be 'N'.
Take a router ,process the rows which are having the 2nd
variable value as 'N' to the target....these are unique recs
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
which one is better performance wise joiner or look up
Design a mapping to load the cumulative sum of salaries of employees into target table?
What do you mean incremental aggregation?
what is the Default Source Option For Update Strategy Transformation?
What is workflow manager?
How to join three sources using joiner?
Explain the informatica workflow?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is Data Caches size?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How can repository reports be accessed without sql or other transformations?
explain abt ur project architecture?
What are the components of workflow manager?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
