how can we load first and last record from a flat file
source to target?
Answer Posted / dharmendra
SRC QF -> SEQ -> EXP -> AGR -> RTR -> TGT
create a port in expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
th record.create 2 condition in 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.
Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What is mapplet in informatica?
What is joiner change?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain about Informatica server process that how it works relates to mapping variables?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How do you handle two sessions in Informatica
What is powercenter on grid?
What are the main issues while working with flat files as source and as targets ?
What is the difference between a connected look up and unconnected lookup?
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)
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the types of lookup transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Scheduling properties,whats the default (sequential)
What is the meaning of up gradation of repository?