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
- 34049 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
What is an expression transformation?
How to load a Dimension ? and how to load a fact table?
Define enterprise data warehousing?
What are the main issues while working with flat files as source and as targets ?
Explain sql transformation in script mode examples in informatica
Explain informatica architecture - version 8 / 9
Please let me know how to make Data masking in informatica..
Which means the first record should come as last record and last record should come as first record and load into the target file?
How you can differentiate between connected lookup and unconnected lookup?
Explain what are the different types of transformation available in informatica.
What are the advantages of informatica?
What is the need of etl tools?
Briefly define reusable transformation?
Briefly describe lookup transformation?
What happens when a session fails and you click on recover?
