in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / prasuna
Ya ..that is right in case its a table..in case of flat
file..i think we cannot use Over ride ...i think using
sequence generator or by finding rownum in Expression
transformation ..after that by filtering two rows ..we get
the output..
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can informatica be used for an organization?
Describe an informatica powercenter?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Can we create two repositories on same database instance in oracle?
Write the unconnected lookup syntax?
What is aggregator transformation in informatica?
What is domain and gateway node?
What is mapping debugger?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
what is the size of u r source(like file or table)?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the difference between informatica 7.0 and 8.0?
Is there any way to read the ms excel datas directly into informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com