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
- 6389 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 tuning techniques you applied during your last project
What is an expression transformation?
What are roles and groups and benefits of using them?
Explain the different lookup methods used in informatica?
How to Create a folder using pmrep command?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the meaning of decode in informatica?
What is sq transformation?
How do you update the records with or without using update strategy?
Implementation methodology
define galaxy repository in informatica
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are some examples of informatica etl programs?
Differentiate between router and filter transformation?
