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 / 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.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the etl program with few examples.

546


What is decode in static cache?

586


Explain pushdown optimization and types in informatica

666


Different qualification between a related rotate toward the sky and isolates look upward?

551


What is difference between a gateway node and worker node?

621






Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1554


What can we do to improve the performance of informatica aggregator transformation?

616


Mention few advantages of router transformation over filter transformation.

633


What is a connected transformation?

672


What are mapplets?

816


What is Data Caches size?

652


What do think which one is the better joiner or look up?

724


What are the issues you have faced in your project? How did you overcome those issues?

1910


How many number of sessions can one group in batches?

688


How many ways a relational source definition can be updated and what are they?

577