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?
Answers were Sorted based on User's Feedback
Answer / ap
Use the target table as lookup and check for the existance
of the rows from source in the lookup. If the row already
exists then ignore and only pass the new rows to the target.
Is This Answer Correct ? | 18 Yes | 3 No |
Answer / vinod
Use Update Strategy Transformation. Identity an unique
field or an unique combination which is the primary key.
Check the primary key field or combination field in Update
stratergy based on which the target is updated. If the key
from the source matches with the target key field, then
these rows not inserted into the target, else it gets
inserted
Correct me if I am wrong
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / kishore
Hi this will do by using INCREMENTAL LOADING.
We should delete records on staging area by using presql on
target(staging).
now staging having only new records..
Is This Answer Correct ? | 2 Yes | 8 No |
Answer / 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 |
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is option by which we can run all the sessions in a batch simultaneously?
How to read data from flat file source if the data is in paragraph format?
what is Active lock explain
Which transformation should we use to normalise the COBOL and relational sources?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
how u know when to use a static cache and dynamic cache in lookup transformation.
Explain one complecated mapping?
why we need informatica
8.what is mapplet ?give example?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica