In incremental loading using Mapping variable if session
failed with any of reason in the middle of process. is the
Mapping variable remains constant or change?
Answer / subhankar chatterjee
Mapping Variable will store its value in the repository once the Session run successfully.If the session fails the Mapping Variable will not be updated with the new value.
| Is This Answer Correct ? | 40 Yes | 1 No |
What is different between the data warehouse and data mart?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
How to eliminate 1st and last rows from the source and load the inbetween rows.
How do you migrate data from one environment to another?
hw cn v elimate dublicate values from lookup without overriding sql?
what is the architecture of any Data warehousing project?
What is active and passive transformation?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
What is IQD file?
Label in Informatica. How to remove existing Label.
what is correlated query?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation