How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
Answer Posted / suresh
scd type 2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do think which one is the better joiner or look up?
What is rank transformation?
What is different between the data warehouse and data mart?
Enterprise data warehouse your projects phase by phase explain?
How to elaborate tracing level?
What is the need of an ETL tool?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is a transaction control transformation?
Briefly define a session task?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain Dataware house architecture .how data flow from intial to end?
Explain the aggregator transformation?
whats the logic to load the lower level of granularity of data to fact table.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?