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
- 3437 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
What is the need for an etl tool?
What is InformaticaPowerCenter?
How to convert multiple rows to single row (multiple columns) in informatica
Is it possible to define a single node as a Gateway node as well as worker node?
How to update source definition?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
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
Which transformation should we use to normalise the COBOL and relational sources?
How many numbers of sessions can one group in batches?
Design time, run time. If you don't create parameter what will happen
What is a node in Informatica?
Explain sessions. Explain how batches are used to combine executions?
Partition, what happens if the specified key range is shorter and longer
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
