Interested to Buy Any Domain ? << Click Here >> for more details...
if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
- 7 Answers
- 9327 Views
- I also Faced
- E-Mail Answers
Answer Posted / lakshmi
Use aggrigator transformation group by port as eno
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explain the shared cache and re-cache?
Different sorts of metadata that stores in the storage facility?
Differentiate between Load Manager and DTM?
What is the use of transformation?
Explain sql transformation in script mode examples in informatica
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
How to join three sources using joiner?
What is lookup change?
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?
can we override a native sql query within informatica? Where do we do it?
How to partition the Session?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Define sessions in informatica etl?
How you know when to use a static cache and dynamic cache in lookup transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
