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
- 6876 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
Why filter transformation is an active one?
What are the types of schemas we have in data warehouse.
What are the various types of transformation?
What is the use of transformation?
How do you load alternate records into different tables through mapping flow?
How to call shell scripts from informatica?
COM components can be used in Informatica
Can we create multiple integration service on single repository?
can u give example for factless fact table
How do you take back up of repository?
Explain lookup transformation in informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How do you manage the Parameter files while migrating your data from one environment to another environment?
How can we handle two sessions in informatica?
