Interested to Buy Any Domain ? << Click Here >> for more details...
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG
I need to get max date and its corresponding flag for both the date columns.
Ex:-
1A,10/3/2015,AC,10/3/2015,XY
1A,10/4/2015,AB,10/2/2015,XZ
Output needed
1A,10/4/2015,10/3/2015,XY
I have 100 million + in the table so avoid self-join...
- 2 Answers
- 4328 Views
- Amex, I also Faced
- E-Mail Answers
Answer Posted / krish
can be implemented in Information using variable ports. think of current value and previous value
https://etltechsolutions.wordpress.com/2015/11/04/oracle-scenario/
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why do you use Mapping Parameter and mapping variable?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain the aggregator transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
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 is the use of code page?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Enlist the advantages of informatica.
How an expression transformation differs from aggregator transformation?
What are the components of Informatica? And what is the purpose of each?
What do you understand by SOA of Informatica?
what is $$$$?
Make a note of the quantity vaults made in informatica?
how tokens will generate?
Is it possible to define a single node as a Gateway node as well as worker node?
