i have two coloumn
emp_no sal
1 3000
2 3000
3 3000
4 4000
5 5000
6 2700
7 4500
i just need output by removing duplicate.my answer should be
emp_no sal
1 3000
2 4000
3 5000
and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
- 3 Answers
- 6868 Views
- I also Faced
- E-Mail Answers
Answer Posted / nsatyabrat7
Use distinct in source qualifier and rest will be taken care
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to implement security measures using repository manager?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What does command task mean?
Enlist the tasks for which source qualifier transformation is used.
Is there any target staging area in informatica not staging area
Which means the first record should come as last record and last record should come as first record and load into the target file?
Where can we find the throughput option in informatica?
How to open an older version of an object in the workspace?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain what transformation and how many are there in informatica?
What is rank transform?
wat are deployement groups in informatica, how it will be used for developers
