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.

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

What are the types of metadata that stores in repository?

2 Answers  

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,

What are differences between Informatica 7.1 and 6.1

3 Answers  

State the differences between sql override and lookup override?

0 Answers  

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

can we see default group,when we use router?if yes how?

2 Answers   L&T,

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,