i have thousand records in my source(flat file) i wanna load
990 records i don't want load first 5 records and last 5
records at informatica level?
- 3 Answers
- 8151 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sehaj
PASS RECORDS FROM SOURCE QUALIFIER TO EXPRESSION.
CREATE A VARIABLE WITHA GGREGATION AS COUNT N ASSIGN ITS VALUE AS 0.
CREATE TWO PARAMETRES N ASSIGN DEM VALUES.
FIRST ONE 5
SECOND ONE 995
.
IN EXPRESSION CREATE AN OUTPUT PORT AS NUMBER DATATYPE N IN THE EXPRESSION EDITOR WRITE....
SEQUENCE=SETCOUNTVARIABLE(VARIABLE NAME U CREATED).
NOW
ATTACH IT TO THE ROUTER
CREATE A GROUP AND ENTER CONDITION
SEQUENCE>5 AND SEQUENCE<995
CONNECT THIS PORT TO TARGET...
SEHAJ....
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are pre and post-session shell commands?
What is status code in informatica?
Different sorts of metadata that stores in the storage facility?
What are the databases that informatica can connect to windows?
How do you change a non-reusable transformation to reusable transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain lookup transformation source types in informatica
Explain the informatica workflow?
What is meant by active and passive transformation?
What is a node in Informatica?
How many ways are there to do 'remove duplicate records in informatica'?
Can anyone tell me the new features in Informatica 9 Version?
How do you update the records with or without using update strategy?
What is a sorter transformation?
What is DR strategy for Informatica project?
