Interested to Buy Any Domain ? << Click Here >> for more details...
how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 10973 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
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is the meaning of up gradation of repository?
what is size of u r database?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How can a transformation be made reusable?
Mention few power centre client applications with their basic purpose?
Explain what are the different types of transformation available in informatica.
Which is the t/r that builts only single cache memory?
Explain scd type 3 through mapping.
What are the main features of Oracle 8i with context to datawarehouse?
What are connected or unconnected transformations?
What is persistent lookup cache?
How to generate sequence numbers without using the sequence generator transformation?
lookup transformation with screenshots
Explain the features of connected and unconnected lookup.
