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
- 10988 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
How can we remove the duplicates from flat file source?
What are the differences between a connected lookup and unconnected lookup?
How will the document be delivered to me?
Separate from an archive server and a powerhouse?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How do you load unique records into one target table and duplicate records into a different target table?
Differentiate between router and filter transformation?
If informatica has its scheduler why using third party scheduler?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
pmscmd startworkflow -sv
Name the different lookup cache(s)?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain dynamic target flat file name generation in informatica
Which means the first record should come as last record and last record should come as first record and load into the target file?
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 .
