I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
- 6 Answers
- 13602 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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is informatica? Why do we need it?
Explain the scenario which compels informatica server to reject files?
Please let me know how to make Data masking in informatica..
Which are the different editions of informatica powercenter that are available?
Slowly changing dimensions, types and where will you use them
What is powercenter on grid?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What the difference is between a database, a data warehouse and a data mart?
Repository user profiles
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)
What are the guidelines to be followed while using union transformation?
What is a router transformation?
