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

what is INFORMATICA TESTING process

0 Answers  

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers   Wipro,

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

How to elaborate tracing level?

0 Answers  

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  

---

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---

How union transformation is active ?

2 Answers   Puma,

---

What is a poling?

2 Answers  

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---