If we set dd_insert in mapping and Delete in session properties what will happen.?
Answers were Sorted based on User's Feedback
Answer / sweta kedia
Yes it will perform delete as session properties overrides
mapping properties.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / insha
It will perform delete operation since session defines run
time properties of mapping
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / usha
It will perform delete.
because session properties overide mapping properties.
| Is This Answer Correct ? | 3 Yes | 1 No |
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
How to merge First Name & Last Name?
What are the databases that informatica can connect to windows?
Differentiate between mapping parameter and mapping variable?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
in performance wise union is past,union all is past
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
how to obtain performance data for individual transformations.
What is a transaction control transformation?
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
why u go for dimensions ?