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
- 34004 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
How many ways a relational source definition can be updated and what are they?
What is rank transform?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is a connected transformation?
Define joiner transformation?
What is the difference between informatica 7.0 and 8.0?
How to use procedural logic inside infromatica?
What is data transformation manager process?
Explain target update override in informatica
What is sq transformation?
What is a repository manager?
Is it possible to use a client with different version than that of its Informatica server?
Differentiate between a database and data warehouse?
What is a repository? And how to add it in an informatica client?
