i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.
Answer Posted / vivek ranjan
I Think that you run the queary
select * from tablename where unique_no = 0 and unique_no =
5.
Definitally you featch 1 and 5 record every time when you
execute queary.
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
Mention few power centre client applications with their basic purpose?
What are the different types of olap? Give an example?
What is status code in informatica?
Informatica settings are available in which file?
What are multi-group transformations?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is informatica? Why do we need it?
What are the differences between oltp and olap?
What is joiner transformation in informatica?
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
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Can we create two repositories on same database instance in oracle?
What is the use of an aggregator cache file?
What is rank transform?
What are the tuning techniques you applied during your last project