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
Answers were Sorted based on User's Feedback
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 |
Answer / jayachandra
One solution is use distinct key word on source qualfier as
suppose your table name is emp than on emp_sq
the query is
select emp_no,distinct sal from emp;
2nd sol is make an aggregator transformation here make a
coun()on sal port with group by then put filter
transformation with condition count(sal)=1
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nsatyabrat7
Use distinct in source qualifier and rest will be taken care
| Is This Answer Correct ? | 0 Yes | 3 No |
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
What is a look up function? What is default transformation for the look up function?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the default join that source qualifier provides?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
How to update a particular record in target with out running whole workflow?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
What is meant by target load plan?
how to obtain performance data for individual transformations.
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
explain about unit testing? in real time?