Hi Experts , Can you please help me regarding the below
question How to remove first three rows and last three rows
in informatica.. thanks and regards Natraj
- 2 Answers
- 5779 Views
- I also Faced
- E-Mail Answers
Answer Posted / rampriya
To skip first n of lines,
If source is DB, then use
select * from emp_details where rownum>3
If the source is flat file, then set Number of Initial lines
to skip=3 in session level property
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How we can create indexes after completing the loan process?
explan ur project architecture?
design of staging area?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How many ways a relational source definition can be updated and what are they?
How many dimensions are there in informatica?
How to load last n records of file into target table - informatica
What is the difference between STOP and ABORT options in Workflow Monitor?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Why do you use Mapping Parameter and mapping variable?
Scheduling properties,whats the default (sequential)
How do you manage the Parameter files while migrating your data from one environment to another environment?
4 yrs etl devloper roles and responsibilities?any body give solutions
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to extract sap data using informatica? What is abap? What are idocs?
