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.

Answer Posted / rakesh

We can generate using MAPPING VARIABLE with SETCOUNTVARIABLE() function

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load last n records of file into target table - informatica

600


What is the advantage of informatica?

650


Explain the different kinds of facts.

566


what is $$$$?

1742


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7683






What is expression transformation?

637


Design a mapping to load a target table with the following values from the above source?

886


Why sorter is an active transformation?

758


What are multi-group transformations?

566


What is the difference between writing a joiner query in ANSI style and THETA style?

1925


server hot-ws270 is connect to Repository B. What does it mean?

1859


What is difference between a gateway node and worker node?

630


What is the difference between a repository server and a powerhouse?

820


What is the surrogate key?

644


What is the difference between informatica 7.0 and 8.0?

569