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

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal.
Is there any othere transformation than the aggrator? if
yes how?

Question Posted / talluru.sankar naidu

Answer Posted / talluru.sankar naidu

we can use SQ transformation write the query we get ans


select sun(sal) from emp where deptno=10 and deptno=5;



I think its correct

Is This Answer Correct ?    1 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is informatica metadata and where is it stored?

622

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1524

Explain in detail about scd type 1 through mapping.

601

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1861

What are the different types of repositories created using informatica?

671




pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1065

What is the surrogate key?

651

What is the function of look up transformation?

664

How to handle decimal places while importing a flatfile into informatica?

735

How might one distinguish in the case of mapping is right or not without associating session?

650

What is informatica metadata and where is it stored?

602

Mention some types of transformation?

616

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3338

Is stop and abort are same in informatica?

578

How can we handle two sessions in informatica?

627