Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
No Answer is Posted For this Question
Be the First to Post Answer
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
What is the difference between Power Centre and Power Mart?
What is a unit Testing?
If you want to create indexes after the load process which transformation you choose?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
What is synonym?
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
how many types transformations supported by sortedinput?
we have to use order by,where,having we to implement sql query
how can u avoid duplicate rows in flat file?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
How to improve the performance of a session using sorter transformation?