Answer / akash

I can suggest 2 ways of obtaining the results:

1. Through source qualifier, filter and sequence generator:
From source qualifier get the total records count in one
port, say record_count and from sequence generator add an
input port, say record_number.

In the filter add the condition:
(record_number > 3) AND (record_number < (record_count - 2))

2. Using the following sql query: (not sure about the
results. Please confirm the same and suggest any updates if
required):

select key_field, DESCRIPTION from temp_table
where
ROWID NOT IN (SELECT ROWID FROM TEMP_TABLE WHERE ROWNUM <=
3)
AND ROWID IN (SELECT ROWID FROM TEMP_TABLE WHERE ROWNUM <=
(SELECT COUNT(*) FROM TEMP_TABLE) - 3)

In the above query temp_table is the table name, key_field
and Description are column names.

Answer / 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

Name the different lookup cache(s)?

0 Answers  

---

How is Data Models Used in Practice?

1 Answers  

---

What is a taget load order?

2 Answers   IBM,

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

---

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

---

In any project how many mappings they will use(minimum)?

1 Answers  

---

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

---

How can you generate reports in informatica?

0 Answers  

---

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  

---