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
- 7867 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 |
What is powercenter on grid?
list out all the transformations which use cache?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
What is a shortcut and copy in Informatica and how two are different with each other?
what is the difference between Informatica 7.1 and Abinitio?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
Why should we use star schema in datawarehouse design?
Teradata 
