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.

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

design of staging area?

0 Answers  

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

What is the need of building a data warehouse?

2 Answers  

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  

What is expression transformation?

0 Answers  

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

Describe two levels in which update strategy transformation sets?

1 Answers  

what is left outer join?

3 Answers   L&T,

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,