What are the options in the target session of update
strategy transsformatioin?
- 2 Answers
- 9723 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
Insert
Delete
Update
Update as update
Update as insert
Update esle insert
Truncate table
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / santhoshi
INSERT
UPDATE AS UPDATE
UPDATE AS INSERT
UPDATE ELSE INSERT
DELETE
TRUNCATE TARGET TABLE
| Is This Answer Correct ? | 2 Yes | 1 No |
.prm wirh repalce .txt is possible?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
What is enterprise data warehousing?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Differentiate between a database and data warehouse?
What is Java Transformation? what are the uses of it?
What is a look up function? What is default transformation for the look up function?
What is a stored procedure transformation?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
Where is metadata stored?
Teradata 
