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
- 7553 Views
- I also Faced
- E-Mail Answers
Answer Posted / nsatyabrat7
Use distinct in source qualifier and rest will be taken care
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What do you mean by worklet?
Different circumstance which drives informatica server to expel records?
What do think which one is the better joiner or look up?
What are the main features of Oracle 8i with context to datawarehouse?
what is index?how it can work in informatica
Briefly explain the aggregator transformation?
Partition, what happens if the specified key range is shorter and longer
What are the types of caches in lookup?
Explain about Informatica server process that how it works relates to mapping variables?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain joiner transformation in informatica
How many dimensions are there in informatica?
What is a sorter transformation?
