Interested to Buy Any Domain ? << Click Here >> for more details...
How to create a mapping ?
id date
101 2/4/2008
101 4/4/2008
102 6/4/2008
102 4/4/2008
103 4/4/2008
104 8/4/2008
O/P - shud have only one id with the min(date)
How to create a mapping for this
- 9 Answers
- 19568 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / deepak
SQ --> Sorter (sort on date desc) --> Aggregator (select no ports so it will always return last row) --> Target
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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.
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
How many number of sessions can one group in batches?
generate date / time dimension in informatica
What does command task mean?
server hot-ws270 is connect to Repository B. What does it mean?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What do you mean by enterprise data warehousing?
my source is junk data how will u remove that junk data by using unix please any one replay me
Differences between version 7.x and 8.x.
Make a note of the quantity vaults made in informatica?
How can one identify whether mapping is correct or not without connecting session?
Write the program through which the records can be updated?
what is index?how it can work in informatica
permutations of mapplet
