how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 9089 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
What are the differences between a connected lookup and unconnected lookup?
What is decode in static cache?
tell me 5 session failure in real time how can you solve that in your project?
What is sequence generator transformation in informatica?
What are the performance considerations when working with aggregator transformation?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Explain constraint based loading in informatica
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.
How to elaborate powercenter integration service?
Parameter and variable differences
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How do you update the records with or without using update strategy?
Explain the features of connected and unconnected lookup.
What is the need of an ETL tool?
Global and Local shortcuts. Advantages.
