Interested to Buy Any Domain ? << Click Here >> for more details...
source : col1 101 101 101 102 102 102 103 103 103
col2 1000 1500 2000 1200 2300 3000 2400 1300 2000
i need target as
col1 101 102 103
col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
- 6 Answers
- 11228 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kiran
USE SOTER TR . IN SORTER TR CLICK ON DISTINCT OPTION IT ELIMINATE THE DUPLICATE AS WELL AS SORT THE ORDER.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
how to load rows into fact table in data warehouse
if we have a delimiters at unwanted places in a flat file how can we over come those.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Differentiate between router and filter transformation?
Informatica settings are available in which file?
What is domain and gateway node?
How many numbers of sessions can one group in batches?
Define update strategy?
How does the aggregator transformation handle null values?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the advantage of informatica?
Is stop and abort are same in informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
can anyone explain me about retail domain project in informatica?
How can one identify whether mapping is correct or not without connecting session?
