source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
Answers were Sorted based on User's Feedback
source-->sq-
| \-------------|
| --->aggr--->target
in target create a new column maxsal now drag the source and
target to the mapping area connect the source to sq.from sq
create two pipelines connect the first pipeline to the target
and the second pipeline to the aggr t/r in aggr t/r create a
new port max_sal=max(sal) connect this pipe line to the target
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / abhinav prakash
1.Pass the ports to an expression t/r.
create a dummy port and give the value as '1'
2.Pass only the salary port to an Aggregator t/r.
Create a dummy port with the same data type and column name
and value as expression.
create o/p port:max(salary)
3.Join these 2 t/r using joiner and join on the dummy port.
ensure u have checked the sorted input option.
4Pass the o/p to the target.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ravikishore
JAMES YOUR ANSWER IS CORRECTIN IN ORACLE,BUT I WANT ANSWER
IN INFORMATICA LEVEL AND UR SOURCE IS FLAT FILE HOW TO DO
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / babu
HI James and Simha,
I think u r answer is wrong,please check once.
as per my knowledje,the query is
SELECT E.*,M.MSAL FROM TABLE_NAME E,(SELECT MAX(SAL) MSAL
FROM TABLE_NAME) M;
IF U R SOURCE IS FLATFILE,U NEED TO GO FOR BELOW MAPPING.
SQ----->TRG_TABLE
|
|---->AGG(MAX(SAL))--->TRG_TABLE(MSAL)
IN THE ABOVE DFD IS
1 SOURCE TO TARGET DIRECT MAPPING ALL COLUMNS EXCEPT
MSAL COLUMN.
2.IN THIS DFD FIND THE MAXSAL AND LINK TO IT MSAL IN
THE TARGET TABLE.
IF THERE IS ANY WRONG PLEASE CORRECT ME.
THANKS,
Babu
Is This Answer Correct ? | 1 Yes | 3 No |
in realtime which situations u can use unconnected lookup transformation
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
task is running successfully but data is not loded why?
why dimenstion tables are denormalized in nature ?
what are challenges that you faced in testing? give solution to it?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
replace multiple spaces with single space.
What is a node in Informatica?
Define error Threshold?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?