Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9229 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 is deployment group?
How does a rank transform differ from aggregator transform functions max and min?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is decode in static cache?
Define enterprise data warehousing?
Can we get 1st record through Informatica(without sequence number).
Is there any target staging area in informatica not staging area
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are mapplets? How is it different from a Reusable Transformation?
can we override a native sql query within informatica? How do we do it?
Which is the t/r that builts only single cache memory?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the databases that informatica can connect to windows?
What is repository manager?
What is Cognos script editor?
