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?
Answer Posted / 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 |
Post New Answer View All Answers
What is Cognos script editor?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is lookup change?
what is the size of your data warehousing?
What does role playing dimension mean?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
pmscmd startworkflow -sv
What is lookup transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the types of schemas we have in data warehouse.
Explain the tuning lookup transformation - informatica
How to improve the performance of a session using sorter transformation?
What is informatica etl tool?
Performance tuning in UNIX for informatica mappings?