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
- 33963 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 are the features of complex mapping?
What are the different lookup cache(s)?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain direct and indirect flat file loading (source file type) - informatica
What is the status code in stored procedure transformation?
What is the function of look up transformation?
Why filter transformation is an active one?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What's the layout of parameter file (what does a parameter file contain?)?
What is the reusable transformation?
expain about the tune parameters?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are the main features of Oracle 8i with context to datawarehouse?
Can you use flat files in Mapplets.
What is meant by query override?
