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
- 9236 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / lakshmi
source--->source qualifier--->sequencegenerator--->
exp--->router--->target.
Take nextval port and assign to exp
In router write condition below as
nextval>=5 and nextval<=995
copy all the ports from router to target
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / swathi
SOURCE->SQ->EXP->ROUTER->TARGET
After sq take seq or exp in exp using variable port concept create seq id like
v_count=count+1;
create output port assign variable port to output like
o_count=v_count
next take router and pass output port to router give condition
o_count>=5 and o_count<=985
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the uses of a Parameter file?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
What are teh different tasks that can be created in workflow manager?
Please let me know how to make encryption and decryption with example?
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
How do you implement scheduling in Informatica?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
What is Code Page Compatibility?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Can you generate sequence numbers without using the sequence generator transformation?
How you prepared reports for OLAP?
Teradata 
