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
- 4168 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 |
What are the main features of Oracle 8i with context to datawarehouse?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
Explain in detail scd type 2 through mapping.
what is scd?
what is the Default Source Option For Update Strategy Transformation?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
In ur current projectu have done any performance tuning of mappings?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
can u any challenge your project?
Teradata 
