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
What is lookup transformation?
Write the unconnected lookup syntax?
How to update a particular record in target with out running whole workflow?
What is informatica metadata and where is it stored?
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 resilience time?
What is sorter transformation?
How to delete duplicate row using informatica?
Define update strategy?
How to create or import flat file definition in to the warehouse designer?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How do you use reject loader.
Is stop and abort are same in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab