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|
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
HOW TO GET THE LATEST DATA IN SCD ?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
What happens when a session fails and you click on recover?
Roles and Responsibilties of Informatica Production Support Member?
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
what is the difference between informatica6.1 and infomatica7.1
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
 Code page compatibly –Where all changes are made to handle the scenario.
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
How to update or delete the rows in a target, which do not have key fields?