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.
- 5 Answers
- 33964 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 35 Yes | 14 No |
Post New Answer View All Answers
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain load alternative records / rows into multiple targets - informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is deployment group?
waht type of interface is used for testing the data in informatica
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Differentiate between Load Manager and DTM?
Define update strategy?
What does refresh system mean, and what are its distinctive choice?
What are the transformations that are not supported in mapplet?
Which transformation is needed while using the Cobol sources as source definitions?
While migrating the data from one environment to another environment how would you manage the connections?
Explain informatica architecture - version 8 / 9
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.
Explain dynamic target flat file name generation in informatica
