1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / sujana

Answer Posted / sujana

@above
wer do we calculate sum here..i think v shud create an o/p
port 4 sum.(sum sal) and grpby eno

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

list out all the transformations which use cache?

681

What are the databases that informatica can connect to windows?

573

whats the logic to load the lower level of granularity of data to fact table.

1789

What are the modules in Power Center

1221

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?

778




What are the different types of transformation available in informatica.

626

What do you mean incremental aggregation?

621

What is an aggregator transformation?

610

Why update strategy and union transformations are active? Explain with examples.

701

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1616

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1463

Explain transaction control transformation in informatica

757

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6745

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

774

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1525