how can one eliminate dupliacte data with out using
distinct option?
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
Explain the features of connected and unconnected lookup.
How do you update the records with or without using update strategy?
What are pre and post-session shell commands?
Explain constraint based loading in informatica
What are session parameters ? How do you set them?
how many types of dimensions are available in informatica?
Explain Dataware house architecture .how data flow from intial to end?
What is standalone command task?
What is a stored procedure transformation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Explain what are the different versions of informatica?
How are indexes created after completing the load process?
Explain the scenario which compels informatica server to reject files?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is dimensional table?