with out using update strategy transnsformation how to
update the data in mapping level
Answer / guest
By using target update override and by using sessions
property treat source rows as update.by using this options
we can update the data
If any statement is wrong try to correct it
| Is This Answer Correct ? | 4 Yes | 0 No |
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
What are the ETL tools available in DWH?
How does the session recovery work.
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
What is difference between maplet and reusable transformation?
what is song in infrmatica...?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
What are conformed dimensions?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
without matching columns in two tables. how can you join