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
- 8951 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 |
when will we go for unconnected lookup transformation in Informatica?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
How to extract the informatica rejected data?
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
Describe the impact of several join conditions and join order in a joiner transformation?
Can we run session without using workflows?
How to display First letter of Names in Caps?
What is an MDDB? What is the difference between MDDBs and RDBMSs?
How to compare Source and Target table, without using dynamic lookup?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
Teradata 
