How to update records in Target, without using Update Strategy?
Answer Posted / pooja
YES WITHOUT A pk WE CANT UPDATE THE REC....
IN SESSION PROPERTIES WE HAVE ONE OPTION TREAT ALL ROWS
AS... THERE U SELECT UPDATE OPTION AND IN THE TARGET
PROPERTIES SELECT UPDTAE OPTION
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
what are 3 tech challenges/ common issues you face?
Define enterprise data warehousing?
How can you validate all mappings in the repository simultaneously?
What do think which one is the better joiner or look up?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
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
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How can informatica be used for an organization?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is rank transform?
What are the restrictions of union transformation?
How many transformations can be used in mapplets.
What if the source is a flat-file?
How to Create a folder using pmrep command?
how to load rows into fact table in data warehouse