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

how to we create datamart?

2 Answers   HSBC,

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

Why we use stored procedure transformation?

4 Answers  

---

what is the size of your data warehousing?

0 Answers   IBM,

---

Explain incremental aggregation in informatica

0 Answers   Informatica,

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---

How will you combine 3 different sources with a single source?

3 Answers  

---

how we load the data from source to staging area

4 Answers   TCS,

---