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 |
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
how to duplicates from expression transformation without using sorter before that
Flat file heaving 1 lack records and I want to push 52000 records to the target?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
what are the limitation of sorter transformation?
Why update strategy and union transformations are active?
how to use incremental load?
which quality process u can approach in ur project
From where we can start or use pmcmd?
Why do you use Mapping Parameter and mapping variable?
why we need informatica