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
- 36200 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
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain your project of banking domian.
What is difference between a gateway node and worker node?
Explain transaction control transformation in informatica
What is informatica? Why do we need it?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How can we use mapping variables in informatica? Where do we use them?
What is the function of union transformation?
can we override a native sql query within informatica? How do we do it?
What is the difference between Active and Passive transformation?
What is the scenario which compels informatica server to reject files?
Explain pushdown optimization and types in informatica
how to create user defined function (udf) in informatica
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
