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
- 36184 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 an aggregator transformation?
How to join three sources using joiner?
How to load a Dimension ? and how to load a fact table?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is transformation?
What are the tasks that can be performed using sq?
What is the Process to creating lookup transformation in informatica
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the different versions of informatica?
What is the commit type if you have a transaction control transformation in the mapping?
Is it possible to use a client with different version than that of its Informatica server?
Explain the mapping variable usage example in informatica
How to delete duplicate row using informatica?
