What are the options in the target session of update
strategy transsformatioin?
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 |
What does reusable transformation mean?
how can we load starting with 11th record of a table from source to target
What are ETL Tools?
how can we use sorter transformation in joins?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is incremental aggregation ,with example?
How to create the source and target database connections in server manager?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
why sequence generator should not directly connected to joiner transformation ?
Explain the different dimensions.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in