Interested to Buy Any Domain ? << Click Here >> for more details...
i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow
- 3 Answers
- 11465 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / pradeepa
We can use an aggregator to group by on deptno and create a
newport to find the max(salary) and load dept no and
salary,we'll get unique deot no and the max salary.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
What is the fact table?
Explain the etl program with few examples.
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explain sessions and how many types of sessions are there?
What is meant by pre and post session shell command?
How to improve the performance of a session using sorter transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
list out all the transformations which use cache?
What is a shortcut and copy in Informatica and how two are different with each other?
How many transformations can be used in mapplets.
What's the layout of parameter file (what does a parameter file contain?)?
What is dimensional table? Explain the different dimensions.
What is data caches/ index caches?
Slowly changing dimensions, types and where will you use them
