Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12903 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / gandra krishna reddy
by using first function in aggregator transformation.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How can we store previous session logs?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What happens when a session fails and you click on recover?
State the differences between sql override and lookup override?
How to improve the performance of a session using sorter transformation?
whats the logic to load the lower level of granularity of data to fact table.
What are the various types of transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
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 can a transformation be made reusable?
What is rank transform?
What is dynamic cache?
what is SDLC way of code development?
