How to extract original records at one target & Duplicate
records at one target?
- 12 Answers
- 19669 Views
- I also Faced
- E-Mail Answers
Answer Posted / shankar
First Pipeline:
SQ--Sort---Tgt1
Second Pipeline:
SQ--Lkp on Tgt1--If The value is matched from both the table
send it to Tgt2.
Use target load plan while u run the session...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse and what are the difference between them?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Performance tuning( what you did in performance tuning)
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
What is a repository? And how to add it in an informatica client?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What do you understand by SOA of Informatica?
What is the different lookup cache(s)?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How we can use union transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the different options available for update strategy?
what is the complex transformation you used in informatica
generate date / time dimension in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
