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
- 10564 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
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is a sequence generator transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to load the data from people soft hrm to people soft erm using informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Briefly define reusable transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is a difference between complete, stop and abort?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a code page?
What are junk dimensions?
explain one complex mapping with logic? sales project?
difference between repository database and repository service?
