Interested to Buy Any Domain ? << Click Here >> for more details...
source table have 3 records? and it is sucessfully loaded
into target. and 4more records is added in to source .that
means 7 records now in source. we have to load the
remaining 4 records into the same trgt table with maintian
top 3 records. how ?can any one give me the data flow of
this logic plz?
- 5 Answers
- 10743 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ajit
just give truncate table option in session properties of
target table.if you dont want to delete the old records and
load from 4th record onwards then you have to use sequence
generator and filter give key>=4
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
expain about the tune parameters?
Can you generate sequence numbers without using the sequence generator transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What is the difference between informatics 7x and 8x and what is latest version?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Define mapplet?
Can u generate reports in Informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain sql transformation in script mode examples in informatica
What are the differences between joiner transformation and source qualifier transformation?
Enlist some properties of sessions.
Explain the code page compatibility?
What happens when a session fails and you click on recover?
Explain how many types of dimensions are available in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
