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 |
What is event and what are the tasks related to it?
Limitation of REPLACESTR. Is there any character limitation to it.
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is source qualifier transformation in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the difference between lookup override and souce qualifier override ?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
How to run a session, which contains mapplet?
What are the steps involved in the migration from older version to newer version of Informatica Server?