Interested to Buy Any Domain ? << Click Here >> for more details...
i have oracle table A and target B. i don't know how many
records. i want get get last record in table A as first record
in target table B. write a sql query?
- 7 Answers
- 11074 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / priyank
In Informatica, make table A as Source and follow the below
mapping:
SRC_A --> AGG --> TGT_B
AGG: Do not check any of the columns for group by and pass
the output to target B. In this way, only the last row will
be passed through.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Which transformation should we use to normalise the COBOL and relational sources?
What is informatica metadata and where is it stored?
What is mapping debugger?
What are the issues you have faced in your project? How did you overcome those issues?
What is the need of etl tools?
What are the different ways to implement parallel processing in informatica?
What is the session task and command task?
What is data transformation manager process?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How to extract sap data using informatica? What is abap? What are idocs?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a mapplet/worklet in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are multi-group transformations?
What are the transformations that are not supported in mapplet?
