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
- 10543 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
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Have you worked with/created Parameter file
Enlist some properties of sessions.
Explain why we use partitioning the session in informatica?
How can repository reports be accessed without sql or other transformations?
Explain lookup transformation source types in informatica
What does “tail –f” command do and what is its use as an Informatica admin.
what is index?how it can work in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Define enterprise data warehousing?
How to join three sources using joiner? Explain though mapping flow.
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is rank transform?
What is union transformation in informatica?
What are the advantages of using informatica as an etl tool over teradata?
