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
- 10680 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the complex transformation you used in informatica
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Explain sessions. Explain how batches are used to combine executions?
What are pre and post-session shell commands?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is informatica? Why do we need it?
Enlist the advantages of informatica.
Different sorts of metadata that stores in the storage facility?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
list out all the transformations which use cache?
How you know when to use a static cache and dynamic cache in lookup transformation?
COM components can be used in Informatica
What is blocking transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
How can informatica be used for an organization?
