in aggregator transformation we want to get middle record
how to implement, source containg empno,name sal,deptno,address
Please follow the below, that would be helpful.
https://www.bullraider.com/database/informatica/scenario/101-informatica-scenario35
| Is This Answer Correct ? | 0 Yes | 0 No |
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
What are the guidelines to be followed while using union transformation?
what is persistant cache in which situation we will use persistantcache
What is the Router transformation?
what is mapping optimization? wat are the techniques for tat
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
What is synonym?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is an expression transformation in informatica?
Which kind of index is preferred in DWH?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out