1)how to generate sequnce numbers in informatica without
using sequnce genarator transformation.
2)i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.
3)i want to update the records without using updatestrategy
transformation.
4)what is diffrance between ab-intio and datastage than
compared to informatica.
5)what is the latest version of informatica in our field.
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 35 Yes | 14 No |
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
Is This Answer Correct ? | 15 Yes | 1 No |
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
Is This Answer Correct ? | 6 Yes | 1 No |
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.
Is This Answer Correct ? | 2 Yes | 1 No |
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is rank transformation in informatica
What are the types of caches in lookup? Explain them.
How do you load alternate records into different tables through mapping flow?
How do you do error handling in Informatica?
How can you change from reusable session into non-reusable session.
What is the meaning of decode in informatica?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How does a rank transform differ from aggregator transform functions max and min?
What is Performance tuning in Informatica?
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 ?
What is the need of etl tools?