If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?
Answers were Sorted based on User's Feedback
Answer / hari
create mapping like
source -- sorter -- expression -- filter -- target.
here sorter is used to send data by ascending order data
this is not mandatory.
Expression is need to create variable port which will count
the rows which are comming in.
Filter having condition like if count value >=51 and count
value <= 100.
| Is This Answer Correct ? | 6 Yes | 0 No |
Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target
src--->sq---> expression--->filter--->target
| Is This Answer Correct ? | 1 Yes | 0 No |
What is a command that used to run a batch?
What is different between informatica version 8 and 9 version
Define update strategy?
What is Datadriven?
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
what is data modelling? what are types of modelling?In which suituation will use each one?
When the informatica server marks that a batch is failed?
tell me the informatica architecture
What all are steps in up gradation of Informatica server?
what is confirmed dimension?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
Write the program through which the records can be updated?