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.
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 are mapplets? How is it different from a Reusable Transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain Dataware house architecture .how data flow from intial to end?
What is rank transformation?
How to load a Dimension ? and how to load a fact table?
How can we improve session performance in aggregator transformation?
Explain the types of lookup transformation?
can we override a native sql query within informatica? Where do we do it?
How to update or delete the rows in a target, which do not have key fields?
How to update a particular record in target with out running whole workflow?
Difference between Target-based loading and constraint-based loading?
What do you mean by enterprise data warehousing?
What is an expression transformation in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?