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
- 36233 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
Can we create multiple integration service on single repository?
What is the need of etl tools?
What are the different types of olap? Give an example?
What is the difference between a connected look up and unconnected lookup?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How do you take back up of repository?
How to load last n records of file into target table - informatica
How many number of sessions can one group in batches?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How do you handle two sessions in Informatica
How to load a Dimension ? and how to load a fact table?
What is the cumulative sum and moving sum?
What is dynamic cache?
Enlist few areas or real-time situations where informatica is required.
what is Active lock explain
