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
- 7859 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
scenario where i can use only concurrent execution of workflow.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How are the sources and targets definitions imported in informatica designer?
What is the difference between a connected look up and unconnected lookup?
How can we update a record in the target table without using update strategy?
Explain what are the different types of transformation available in informatica.
What are session parameters ? How do you set them?
What is sorter transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
whats the logic to load the lower level of granularity of data to fact table.
Difference between Data and Index Caches?
What is primary and backup node?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is a surrogate key?
explan ur project architecture?
