create a mapping to retrieve the employees who are getting
salary greater than average salary?
Answers were Sorted based on User's Feedback
go with this order EXP, AGG, JOINER, FILTER
this will work
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / maxy
I think it's better to have a null check here in the exp
before aggregating.
If salary is Null for any employee it will not be consider
while caculating the avg.
ex-
epm sal
e1 10
e2 20
e3
e4 30
Though there are four employee avg will be 20.
Is This Answer Correct ? | 0 Yes | 6 No |
Answer / 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 |
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
how many data models u have done in informatica project?
How can we integrate different flat file data in a single mapping and with in a single execution
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
what is left outer join?
Write the advantages of partitioning a session?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
hi real timers . iam waiting for ur reply regarding ETL TESTING
how to move the mappings from your local machine to claint place?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?