Interested to Buy Any Domain ? << Click Here >> for more details...
SOURCE
NAME SAL
GANGA 30000
RAJU 20000
PAVAN 25000
TARGET
NAME SAL MAXSAL
GANGA 30000 30000
RAJU 20000 30000
PAVAN 25000 30000
in mapping level how to achive that
- 5 Answers
- 11076 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / pjr
SQ-->Agg-->TGT
in aggrigator create on new out_port max_sal=max(sal) then
give connection to tgt MXASAL
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is meant by a domain?
What are different types of transformations available in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is difference between a gateway node and worker node?
What is meant by pre and post session shell command?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the benefit of partitioning a session?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Can we override a native sql query within informatica?
What is update strategy transform?
How to create Target definition for flat files?
How can you increase the performance in joiner transformation?
How do you convert single row from source into three rows into target?
What are the restrictions of union transformation?
