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
- 10829 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
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain pushdown optimization and types in informatica
How do you use reject loader.
How do you load only null records into target? Explain through mapping flow.
Have you worked with/created Parameter file
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the way to execute pl/sql script using informatica mapping?
What do mean by local and global repository?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the need of etl tools?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How do you take back up of repository?
How do you change a non-reusable transformation to reusable transformation?
Differentiate between a database and data warehouse?
What is a filter transformation and why it is an active one?
