Interested to Buy Any Domain ? << Click Here >> for more details...
how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 11159 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
How would you copy the content of one repository to another repository?
where to store informatica rejected data?
Explain the shared cache and re-cache?
Design a mapping to load a target table with the following values from the above source?
What is informatica etl tool?
What are the tuning techniques you applied during your last project
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is a joiner transformation and why it is an active one?
How can you increase the performance in joiner transformation?
How an expression transformation differs from aggregator transformation?
How to improve the performance of a session using sorter transformation?
Which files are created during the session rums by informatics server?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
expain about the tune parameters?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
