how to load only the first and last record of a flat file
into the target?
Answer Posted / tilak
use sequence generator , pass values only with max and min
sequence number filter to target
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the sql query overwrite in source qualifier in informatica
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain informatica architecture - version 8 / 9
What is the commit type if you have a transaction control transformation in the mapping?
Mention some types of transformation?
What are the new features of informatica 9.x at the developer level?
How might you approve all mappings in the archive all the while?
what is song in infrmatica...?
What is a snowflake schema?
What is deployment group?
What are ETL Tools?
What are the prerequisite tasks to achieve the session partition?
what is diff b/t sorter t/r and agg have the option sorter property...
How are indexes created after completing the load process?