Interested to Buy Any Domain ? << Click Here >> for more details...
1)how to generate sequnce numbers in informatica without
using sequnce genarator transformation.
2)i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.
3)i want to update the records without using updatestrategy
transformation.
4)what is diffrance between ab-intio and datastage than
compared to informatica.
5)what is the latest version of informatica in our field.
- 5 Answers
- 36405 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / kishore
2)i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.
ans:yes we get first and last record from table using
psuedo columns rownum and row id
i.e.,
in source qualifier t/r we caen create user defined queires
their type below query
select * from <table_name> where rownum=1 union select *
from <table_name> where rowid=(select max(rowid) from
<table_name>);
note:<table_name> is the name of the from which u want to
retrieve records
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How are indexes created after completing the load process?
How to Create a folder using pmrep command?
what is song in infrmatica...?
How can you generate reports in informatica?
how tokens will generate?
What is the format of informatica objects in a repository?
What are the main issues while working with flat files as source and as targets ?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Informatica settings are available in which file?
Describe the impact of several join conditions and join order in a joiner transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is domain in terms of informatica?
What are roles and groups and benefits of using them?
On which transformations you created partitions in your project?
What is data transformation manager process?
