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.
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
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How union transformation is used?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the types of schemas we have in data warehouse and what are the difference between them?
How to load a Dimension ? and how to load a fact table?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is meant by lookup transformation? Explain the types of lookup transformation?
difference between repository database and repository service?
What are the main features of Oracle 8i with context to datawarehouse?
How to generate sequence numbers?
How can you increase the performance in joiner transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to create the source and target database connections in server manager?
Why update strategy and union transformations are active?
What is rank transform?