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
- 10656 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / mr lee
Select * From Table A Where ROWID = (Select Max(ROWID) From
Table A
Union
Select * From Table B Where Rownum = 1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Define update strategy?
What is workflow? What are the components of the workflow manager?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How can we remove the duplicates from flat file source?
Informatica Checkpoints
Informatica settings are available in which file?
How can you increase the performance in joiner transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
Briefly explain the aggregator transformation?
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
Explain constraint based loading in informatica
how tokens will generate?
What is meant by a domain?
