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
- 36209 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.
Generate sequence numbers to ur source
connect it to filter t/r and write a condition sno=1 connect it to the target
in second pipeline connect source qualifier to aggreator t/r don't select any group by (so that it will gives it last record) connect output to the target
the flow is like this
sequence generator|
|
\|/
src--->sq--->filter--->target
|
|--->aggrigator--->target
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What is the maplet?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to use pmcmd utility command?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How would you copy the content of one repository to another repository?
Write the unconnected lookup syntax?
permutations of mapplet
What do think which one is the better joiner or look up?
What is different between the data warehouse and data mart?
What is rank transform?
How do you promote a non-reusable transformation to reusable transformation?
Separate from an archive server and a powerhouse?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
To import the flat file definition into the designer where should the flat file be placed?
Does an informatica transformation support only aggregate expressions?
