Interested to Buy Any Domain ? << Click Here >> for more details...
what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
- 2 Answers
- 4202 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
For update strategy t/r we should have Constraints defined
on the table.
Else we'll have to use Update override property in session
properties.
Delete in session property we use for deleting a record
based on condition were as truncate is for removing the
previous record from the table before inserting new set of
data.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is joiner transformation in informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is different between the data warehouse and data mart?
What is a connected transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to create a non-reusable instance of reusable transformations?
What are the conditions needed to improve the performance of informatica aggregator transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what is the size of your data warehousing?
What is incremental aggregation?
How many ways are there to create ports?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is meant by query override?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
whats the logic to load the lower level of granularity of data to fact table.
