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
- 9664 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
Can we get 1st record through Informatica(without sequence number).
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Define update strategy?
What is a mapplet/worklet in informatica?
What are the different types of transformation available in informatica.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the differences between source qualifier and joiner transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is fact table? Explain the different kinds of facts.
Differentiate between source qualifier and filter transformation?
What is confirmed fact in dataware housing?
What is the need for an etl tool?
What is an Integration service in Informatica?
Which files are created during the session rums by informatics server?
What is meant by lookup transformation?
