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
- 36201 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 are the sources and targets definitions imported in informatica designer?
without table how to come first record only in oracle?
How to create the source and target database connections in server manager?
What is the sequence generator transformation in informatica?
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.
What is the sql query overwrite in source qualifier in informatica
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How can you increase the performance in joiner transformation?
Reusable transformation and shortcut differences
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is data movement mode in Informatica and difference between them?
What do you understand by a term domain?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What does role playing dimension mean?
