Interested to Buy Any Domain ? << Click Here >> for more details...
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
- 6 Answers
- 15354 Views
- Cap Gemini, CTS, I also Faced
- E-Mail Answers
Answer Posted / rajesh
Use head and tail command(Pre session command) write it into two files.Use transformation to read that files as per your requirement
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different lookup cache(s)?
generate date / time dimension in informatica
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
write a query to retrieve the latest records from the table sorted by version(scd)
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?
What is Data Caches size?
what is the hint? how to use it to reduce the query processing in program?
How do you set a varible in incremental aggregation
What is rank index in rank transformation?
r u done any partitions in ur project?
Define joiner transformation?
What is intricate mapping?
How does a rank transform differ from aggregator transform functions max and min?
Different qualification between a related rotate toward the sky and isolates look upward?
Enlist the various types of transformations.
