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
- 15335 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
How do you remove duplicate records in informatica? And how many ways are there to do it?
Can you use flat files in Mapplets.
How do you handle two sessions in Informatica
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are connected or unconnected transformations?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to load the data from people soft hrm to people soft erm using informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What do you understand by SOA of Informatica?
Different circumstance which drives informatica server to expel records?
How many number of sessions can one group in batches?
Design a mapping to load the cumulative sum of salaries of employees into target table?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Name the different lookup cache(s)?
How to elaborate tracing level?
