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
- 9101 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to elaborate powercenter integration service?
Why do we need informatica?
How to implement security measures using repository manager?
How many ways are there to create ports?
What are the new features of informatica 9.x in developer level?
What are the tasks that source qualifier perform?
What are the designer tools for creating transformations?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is option by which we can run all the sessions in a batch simultaneously?
What is decode in informatica?
What are pre and post-session shell commands?
What is workflow manager?
How many number of sessions can one group in batches?
