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
- 4395 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vikas
Update Strategy Works on Tables and not on files. In session, Treat source rows should be data driven.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Explain the mapping variable usage example in informatica
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
version controlling in informatica?
What is meant by pre and post session shell command?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
What is deployemnt groups, Lables, query and dynamic deployment group.
what is normalizer transformation?
Can we create a Integration service without a Repository service and vice versa?
How we can confirm all mappings in the repository simultaneously?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
Teradata 
