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
- 5966 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 is mapplet in informatica?
What is an active transformation?
How do you set a varible in incremental aggregation
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is an expression transformation in informatica?
Clarify the aggregator change?
Enlist the differences between database and data warehouse.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is SDLC way of code development?
How many types of sessions are there in informatica.please explain them?
How to partition the Session?
tell me about your project functionality
What is meant by pre and post session shell command?
Explain lookup transformation source types in informatica
Explain joiner transformation in informatica
