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
- 35841 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
How to use procedural logic inside infromatica?
Define the various join types of joiner transformation?
Differentiate between router and filter transformation?
What is source qualifier transformation in informatica?
Can we get 1st record through Informatica(without sequence number).
Explain sessions. Explain how batches are used to combine executions?
What do you mean by blocking transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the performance considerations when working with aggregator transformation?
update strategy transformation in informatica
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
what is the hint? how to use it to reduce the query processing in program?
Explain the difference between mapping parameter and mapping variable?
Explain sessions?
complex mapping ur project u r invlve can u explain and give real time example give me ?
