If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
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|
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Can you create a flatfile target
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? firstname.lastname@example.org
Enlist the advantages of informatica.
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID email@example.com
What are the reusable transforamtions?
what is the difference between repository & Intergration service
What all are steps in up gradation of Informatica server?
can we use union transformation in joiner transformation?how?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
How does a rank transform differ from aggregator transform functions max and min?