Interested to Buy Any Domain ? << Click Here >> for more details...
If we have 1000 rows were loaded in to datawarehouse and
next day the source have 1010 rows so, how can we loaded
only updated rows into target.
- 6 Answers
- 11945 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / gazulas
sql override the sq, using a parameter_value.
select * from xxx where date = parameter_value.
pass the value form par file and run it. only particular date records will be extracted....;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is dimensional table?
What do think which one is the better joiner or look up?
What is blocking transformation?
How to differentiate between the active and passive transformations?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is a node in Informatica?
What does reusable transformation mean?
How can one identify whether mapping is correct or not without connecting session?
Clarify the aggregator change?
What is the difference between STOP and ABORT options in Workflow Monitor?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is Index Caches size?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is decode in static cache?
