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
- 36156 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
Which development components of informatica have the highest usage?
Explain lookup transformation source types in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain dynamic target flat file name generation in informatica
what is degenerated dimension?
Explain in detail scd type 2 through mapping.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the databases that informatica can connect to windows?
What are session parameters ? How do you set them?
How to convert multiple rows to single row (multiple columns) in informatica
How do you update the records with or without using update strategy?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to update or delete the rows in a target, which do not have key fields?
how to load rows into fact table in data warehouse
what is INFORMATICA TESTING process
