Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
- 15 Answers
- 25869 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / muddam
First declare variable paramater as las_extract_date and
create port as last_updated_date and connect source.qf
transforamtion override, give as where
last_ext_dt>=last_update_date with time stamp it will work
out.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
Describe data concatenation?
How do you load only null records into target?
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?
what is the Default Source Option For Update Strategy Transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How can we use mapping variables in informatica?
Partition, what happens if the specified key range is shorter and longer
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How you can differentiate between connected lookup and unconnected lookup?
How can we store previous session logs?
How do you change a non-reusable transformation to reusable transformation?
Explain transaction control transformation in informatica
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to implement security measures using repository manager?
