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
- 36159 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 can we use batches?
Mention some types of transformation?
What are active transformations.
What is workflow? What are the components of the workflow manager?
When do you use sql override in a lookup transformation?
What does reusable transformation mean?
How do you take back up of repository?
What is a repository? And how to add it in an informatica client?
how we can load rejected record's at run time?(not through bad files)
How do you migrate data from one environment to another?
Write the unconnected lookup syntax?
What are different types of transformations available in informatica?
What is DR strategy for Informatica project?
How would you copy the content of one repository to another repository?
What are the differences between joiner transformation and source qualifier transformation?
