source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000

Answer Posted / james

Hey Babu,

I've tried your query.
It's not working for me.
Please double check it.

And u said my query doesn't work.
It works absolutely fine for me.
Please let me know where my went wrong.

Waiting for your reply.
-James

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are session parameters ? How do you set them?

1369


EXL informatica Questions

924


How to extract sap data using informatica? What is abap? What are idocs?

547


explain abt ur project architecture?

1751


Briefly explain the aggregator transformation?

584






What is a connected transformation?

668


how to load rows into fact table in data warehouse

634


What are the components of Informatica? And what is the purpose of each?

610


How to go to the older version for a mapping?

591


What are multi-group transformations?

554


Define sessions in informatica etl?

609


What are the performance considerations when working with aggregator transformation?

669


Do you find any difficulty while working with flat files as source and target?

664


Define mapplet?

622


how to load dimension table and fact table. plz tell me the steps.

1679