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
- 7551 Views
- I also Faced
- E-Mail Answers
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 |
Explain the shared cache and re-cache?
How do you implement unconn. Stored proc. In a mapping?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
Quickly characterize reusable change?
what are cost based and rule based approaches and what is the difference?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is a joiner transformation?
What is rank transformation?
How can i set break points in debugging mode ? can explain steps please?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
Teradata 
