How to extract original records at one target & Duplicate
records at one target?
- 12 Answers
- 18941 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishnakanth.ch
yes... add a new column in the sql override by calculating
the count(*) to get how many times the record is repeating.
Using Router we can seperate them into two different
targets.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Whats there in global repository
Performance tuning( what you did in performance tuning)
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
The question was on time stamp. what is the difference between HH and HH24 when to use when.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Explain in detail scd type 2 through mapping.
What are the different versions of informatica?
Informatica settings are available in which file?
How can we update a record in the target table without using update strategy?
What is decode in informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the difference between stop and abort in informatica
Write the prerequisite tasks to achieve the session partition?
Explain scd type 3 through mapping.
