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
- 7737 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 the format of informatica objects in a repository?
State the differences between sql override and lookup override?
What is Index Caches size?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
lookup transformation with screenshots
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How will the document be delivered to me?
Explain the code page compatibility?
Why is sorter an active transformation?
have u done any performance tuning? how u ll do?
Enterprise data warehouse your projects phase by phase explain?
What is data caches/ index caches?
design of staging area?
What are the differences between joiner transformation and source qualifier transformation?
How can you define user defied event?
