Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6532 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
Explain the pipeline partition with real time example?
What are the advantages of using informatica as an etl tool over teradata?
How to do the error handling of if ur source is flatfiles?
What are the popular informatica products?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to extract sap data using informatica?
What are the types of schemas we have in data warehouse.
What is sequence generator transformation in informatica?
Explain what are the different versions of informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is the difference between source qualifier transformations source filter to filter transformation?
What is the need for an etl tool?
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
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
