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.

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

How to start a workflow using pmcmd command?

0 Answers  

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

How do you promote a non-reusable transformation to reusable transformation?

0 Answers   Informatica,

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,

What is the need of building a data warehouse?

2 Answers  

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers