i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 11683 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sameer
If our source as a relational table then we write sql queries in sour economy qualifier transformation select * from table-name where rownum <=7
But if our soure as flat file
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to go to the older version for a mapping?
what is unit testing?tell me proceedure
How to join three sources using joiner? Explain though mapping flow.
How might you approve all mappings in the archive all the while?
What is an active transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are pre and post-session shell commands?
How to load data in informatica ?
What is olap (on-line analytical processing?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the conditions needed to improve the performance of informatica aggregator transformation?
Define Pmrep command?
Define the various join types of joiner transformation?
