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
- 8950 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to load last n records of file into target table - informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to use pmcmd utility command?
What are the types of schemas we have in data warehouse and what are the difference between them?
Enlist the advantages of informatica.
Enlist the differences between database and data warehouse.
Define pmcmd command?
What is confirmed fact in dataware housing?
update strategy transformation in informatica
wf dont have integration severances how you can run?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How do you load unique records into one target table and duplicate records into a different target table?
