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
- 36234 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
Differences between version 7.x and 8.x.
Define update strategy?
How do you handle two sessions in Informatica
What are the different types of olap? Give an example?
How union transformation is used?
Plz can any one say me how to get the informatica certification materials and dumps
What are the main issues while working with flat files as source and as targets ?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is rank transformation?
What are the different clients of powercenter?
Which transformation is needed while using the Cobol sources as source definitions?
can anyone explain me about retail domain project in informatica?
What is workflow manager?
What is a joiner transformation and why it is an active one?
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
