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
- 11103 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
What are the mapping parameters and mapping variables?
In which transformation you cannot drag ports into it?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Explain pushdown optimization $pushdownconfig parameter - informatica
How are indexes created after completing the load process?
What are the reusable transformations?
Where do we use mapping variables in informatica?
What is an unconnected transformation?
can you please explain me pre session and post session options?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain what are the different types of transformation available in informatica.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
define galaxy repository in informatica
Explain the aggregator transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
