Interested to Buy Any Domain ? << Click Here >> for more details...
how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 30571 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / ram pothineni
Create a port in Expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
the records. Create 2 condition in router one with SEQ = 1
and another with SEQ = count of rows (this will give last
row). Connect both to target. Dont forget to give reset
option in SEQ generator.
http://it.toolbox.com/people/raambabuchowdary/
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is olap (on-line analytical processing?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
tell me the rules and responsblites in our project(my project is development)
What are roles and groups and benefits of using them?
can u any challenge your project?
What is the sql query overwrite in source qualifier in informatica
How do you update the records with or without using update strategy?
Informatica settings are available in which file?
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 create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Performance tuning in UNIX for informatica mappings?
How to create Target definition for flat files?
What are the different types of transformation available in informatica.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is a rank transform?
