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
- 36187 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 is a code page?
What is the commit type if you have a transaction control transformation in the mapping?
How to load last n records of file into target table - informatica
How can informatica be used for an organization?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How can we improve session performance in aggregator transformation?
How do you promote a non-reusable transformation to reusable transformation?
How to start a workflow using pmcmd command?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain incremental aggregation in informatica
What is resilience time?
What is joiner transformation in informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
How do you change a non-reusable transformation to reusable transformation?
Target increases every day even though no new record was inserted
