Interested to Buy Any Domain ? << Click Here >> for more details...
how we can update a target table without update strategy and
update override?
- 3 Answers
- 7548 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / moorthy g
In Session Properties
Treat source row as: update
This way you can update in the target
Best Regards
Moorthy. G
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / bhupal
In session properties we can use update as update to update the target but target should contain the primary key in base table or in informatica level.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
Where do you create/define mapping parameter and mapping variable?
How to view and Generate Metadata Reports?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Can we insert ,update ,delete in target tables with one update strategy tran.?
what are objects in data warehouse?
Can I create one wrkflw which will run different wrkflws on schedule time?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
connected and unconnected lookups?
Explain the different kinds of facts.
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
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
Teradata 
