Interested to Buy Any Domain ? << Click Here >> for more details...
How to extract original records at one target & Duplicate
records at one target? {with out using EXPRESION
transformation and sequence generator transformation?}<-this
is important
- 4 Answers
- 10313 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / usha
by using dynamic lkp its possible...
in dynamic lkp if we r having 2 records..
i will inser 1st record and will update second record...
when ever data inserted in to the target cache get
refreshed..
we ttake dynamic lkp..
by defaul..new lkp row port is added...
we should enable the associatve port...
here we should give the condition ..
in router we should give condition as newlkp=1--it will
insert...
if newlkp=0 means duplicate recorts
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / p1khatri
using Dynamic lookup :-
for new record (i.e. Newlookuprow =1)insert into tgt 1
for duplicate records (i.e. Newlookuprow=0) insert into tgt
2
I hope this'll work
| Is This Answer Correct ? | 7 Yes | 6 No |
Answer / yaseen
sort the records with sorter t/r and with aggregator t/r give the group by and add 1 column give the expression as count(col)and in router t/r give condition as count=1 for unique and default for duplicate.
And I think for dynamic lookup newlookport = 0 then it is for no changes right like
0------no changes
1-------insert
2--------update
Plz correct me if I am wrong
| Is This Answer Correct ? | 1 Yes | 0 No |
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
How many cubes create from a single model?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
How to read data from flat file source if the data is in paragraph format?
what is constraint based load order
task is running successfully but data is not loded why?
How to update records in Target, without using Update Strategy?
what happens if you try to create a shortcut to a non- shared folder?
How to use procedural logic inside infromatica?
can we override a native sql query within informatica? How do we do it?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
Teradata 
