Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7107 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / ravindra.15aug
In RDBMS we can write sql queary in Source qualifer by
using rowid, in sorter by using select distinct option, In
aggregator by using groupby, in Rank by using groupby.
In FF level also we can do except sql queary in source
qualifier.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Partition, what happens if the specified key range is shorter and longer
What are the tuning techniques you applied during your last project
Enlist few areas or real-time situations where informatica is required.
Why update strategy and union transformations are active?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are active and passive transformations?
What are the different clients of powercenter?
Whats there in global repository
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What does update strategy mean, and what are the different option of it?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Is stop and abort are same in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to do unit testing in informatica? How to load data in informatica ?
How can we delete duplicate rows from flat files?
