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
- 10990 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
How does a rank transform differ from aggregator transform functions max and min?
How to create Target definition for flat files?
Is it possible to use a client with different version than that of its Informatica server?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What do you mean by channel change?
Enlist few areas or real-time situations where informatica is required.
What is different between the data warehouse and data mart?
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 are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is update strategy transform?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to elaborate tracing level?
What is the different lookup cache(s)?
what are the deliverables?in your project?
