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
- 36419 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 configure mapping in informatica?
What is union transformation in informatica?
On which transformations you created partitions in your project?
Enlist the differences between database and data warehouse.
What are pre and post-session shell commands?
How many ways are there to do 'remove duplicate records in informatica'?
list out all the transformations which use cache?
What is the use of target designer?
Explain informatica architecture - version 8 / 9
How you know when to use a static cache and dynamic cache in lookup transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Why update strategy and union transformations are active?
expain about the tune parameters?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
