create a mapping to retrieve the employees who are getting
salary greater than average salary?
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 to load last n records of file into target table - informatica
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
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
What is the difference between informatica 7.0 and 8.0?
What is a pre-defined event and user-defined event?
where to store informatica rejected data? How to extract the informatica rejected data?
How do you convert single row from source into three rows into target?
What are the static cache and dynamic cache in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is an unconnected transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain target update override in informatica
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Which version configuration tool used in ur project?
Explain the etl program with few examples.