Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 36186 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 can you differentiate between powercenter and power map?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain the scenario which compels informatica server to reject files?
How to configure mapping in informatica?
whats the logic to load the lower level of granularity of data to fact table.
Briefly describe lookup transformation?
Mention some types of transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
permutations of mapplet
What is the benefit of partitioning a session?
Define update strategy?
What all join we can perform in LOOKUP transformation?
What are the types of schemas we have in data warehouse.
Where are the source flat files kept before running the session?
can you please explain me pre session and post session options?
