Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7674 Views
- I also Faced
- E-Mail Answers
Answer Posted / rayudu
First in the pre_session command task remove the duplicates
using the following
cut -d "," -f2 filename|uniq
Now in the file you will have
3000
4000
5000
2700
4500
now after source qualifier keep a expression and generate
the sequence.
Hope it clarifies
Regards,
rayudu
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the different options available for update strategy?
Plz can any one say me how to get the informatica certification materials and dumps
What is a rank transform?
How to load data in informatica ?
Mention few advantages of router transformation over filter transformation.
Is there any way to read the ms excel datas directly into informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the function of union transformation?
What is informatica? Why do we need it?
How does the aggregator transformation handle null values?
What is decode in static cache?
In warehouses how many schemas are there?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the types of lookup transformation?
