in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / prakash kumar kumhar
ower write sq ("select *from <tableNmae> where rownum <= 10;")
than use two aggregation transformation (in first use first(),and in second use last() for each column)from sq to target.
note: use two target table in which u want to load that two records.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
can you please explain me pre session and post session options?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Explain pmcmd command usage in informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is parallel processing in informatica?
Explain how many types of dimensions are available in informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explain what are the different versions of informatica?
What is a node in Informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the fact table?
What is the difference between a connected look up and unconnected lookup?
What is pmcmd command?
write a query to retrieve the latest records from the table sorted by version(scd)