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
- 34014 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
What are the differences between joiner transformation and source qualifier transformation?
Write the prerequisite tasks to achieve the session partition?
Plz can any one say me how to get the informatica certification materials and dumps
which one is better performance wise joiner or look up
Can we create a Integration service without a Repository service and vice versa?
What is lookup 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
How can we handle two sessions in informatica?
Differentiate between source qualifier and filter transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the differences between a connected lookup and unconnected lookup?
Explain the shared cache and re-cache?
explain about unit testing? in real time?
Explain the difference between a data warehouse and a data mart?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
