Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answers were Sorted based on User's Feedback



i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 ..

Answer / rayudu

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

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 ..

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

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 ..

Answer / nsatyabrat7

Use distinct in source qualifier and rest will be taken care

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

What is the use of an aggregator cache file?

0 Answers  


Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,


Mention few power centre client applications with their basic purpose?

0 Answers  


How to load last 10 records of flat file in to the target?

5 Answers   iNautix,


,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,


Have you worked with/created Parameter file

0 Answers  


What is workflow? What are the components of the workflow manager?

0 Answers  


if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,


Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  


why we r using presql&postsql in source qualifier?

1 Answers   HP,


What is hash partition?

2 Answers  


How is union transformation utilized?

0 Answers  


Categories