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
What is decode in static cache?
pmscmd startworkflow -sv
can we override a native sql query within informatica? How do we do it?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to update a particular record in target with out running whole workflow?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are data-driven sessions?
I have a flat file, want to reverse the contents of the flat file
What is an expression transformation?
What are the various types of transformation?
How to extract sap data using informatica? What is abap? What are idocs?
Explain in detail scd type 2 through mapping.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is mapping debugger?
What is blocking transformation?