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 |
which one is better performance wise joiner or look up
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
how we load the data from source to staging area
What is sequence generator transformation in informatica?
What are the types of data that passes between informatica server and stored procedure?
What are the main issues while working with flat files as source and as targets ?
What is up date strategy and what are the options for update strategy?
What is a code page?
can we create index and drop index in exsisting table while using infomatica
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
What is router transformation