Answer / venkateshmalneni

How to generate sequence numbers in informatica with out using sequence generator t/r

we can generate sequence numbers in informatica by using expression transformation also.In expressin t/r create 3 new ports
1)var_1 as variable port and in expression give value as val
2)val as variable port and in expression give value as val+1
3)sequence output port and in expression give val
and connect the output port to target

Answer / venkateshmalneni

i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.

Generate sequence numbers to ur source
connect it to filter t/r and write a condition sno=1 connect it to the target

in second pipeline connect source qualifier to aggreator t/r don't select any group by (so that it will gives it last record) connect output to the target

the flow is like this
sequence generator|
|
\|/
src--->sq--->filter--->target
|
|--->aggrigator--->target

Answer / rakesh

We can generate using MAPPING VARIABLE with SETCOUNTVARIABLE() function

Answer / kishore

2)i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.

ans:yes we get first and last record from table using
psuedo columns rownum and row id
i.e.,
in source qualifier t/r we caen create user defined queires
their type below query
select * from <table_name> where rownum=1 union select *
from <table_name> where rowid=(select max(rowid) from
<table_name>);
note:<table_name> is the name of the from which u want to
retrieve records

Answer / chandrasekar

HI VENKATESH,

YOUR ABOVE ANSWER IS NOT CORRECTLY WORKING IN MY
SYSTEM. SO PLEASE EXECUTE THE ABOVE SOLUTION ONCE AGAIN LOAD
IT. AS PER MY KNOWLEDGE WE CAN CREATE A MAPPING VARIABLE AS
$$SEQ,DATA TYPE IS INTEGER AND SELECT AGGREGATION COLOUMN IS
COUNT. USING EXP TRANSFORMATION SETCOUNTVARIABLE($$SEQ). IT
WILL WORK CORRECTLY.

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

How can you run a session without using server manager?

1 Answers  

---

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

Can we get 1st record through Informatica(without sequence number).

1 Answers  

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

---

What are the issues you have faced in your project? How did you overcome those issues?

1 Answers   CTS, FEEE, TCS,

---

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

---