If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?
- 2 Answers
- 5560 Views
- I also Faced
- E-Mail Answers
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 |
Can we create multiple integration service on single repository?
select count(1) from emp? what is the o/p?
How many ways are there to create ports?
server hot-ws270 is connect to Repository B. What does it mean?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
How union transformation is active ?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is olap (on-line analytical processing?
What do you understand by SOA of Informatica?
how we can do session partition in informatica any one explain me clearly? thanks advance.
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
What is the use of transformation?
Teradata 
