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
- 5750 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
tell me about your project functionality
What is the meaning of up gradation of repository?
How can you define user defied event?
How can we store previous session logs?
Explain pmcmd command usage in informatica
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the types of caches in lookup? Explain them.
What is a surrogate key?
How can we create index after completion of load process?
What are the prerequisite tasks to achieve the session partition?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How would you copy the content of one repository to another repository?
Can u generate reports in Informatica?
How does a rank transform differ from aggregator transform functions max and min?
