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
- 10894 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
Enlist few areas or real-time situations where informatica is required.
Explain the different lookup methods used in informatica?
What is decode in static cache?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the command used to run a batch?
explain about unit testing? in real time?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
generate date / time dimension in informatica
What is rank transformation in informatica
How to elaborate powercenter integration service?
What is intricate mapping?
Explain the pipeline partition with real time example?
How an expression transformation differs from aggregator transformation?
What is flashback table ? Advance thanks
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
