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
- 10989 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
What you know about transaction control transformation?
How we can confirm all mappings in the repository simultaneously?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Router T/R is active but some people are saying it is also passive which is exactly right?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
What are the different threads in DTM process?
What is flashback table ? Advance thanks
Which are the different editions of informatica powercenter that are available?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to improve the performance of a session using sorter transformation?
Teradata 
