create a mapping to retrieve the employees who are getting
salary greater than average salary?
- 4 Answers
- 9274 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / shaik
Source--->EXP--->AGG--->Filter--->Target
by using agg T/f you can find the avg,use that value ti
filter the values by using filter transformation..............
| Is This Answer Correct ? | 4 Yes | 15 No |
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is the meaning of up gradation of repository?
What does reusable transformation mean?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
wf dont have integration severances how you can run?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the restrictions of union transformation?
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?
How big was your fact table
What is the fact table?
How to use pmcmd utility command?
What is the maplet?
What is the sequence generator transformation in informatica?
