i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
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
Explain the mapping variable usage example in informatica
What are the uses of etl tools?
What's the layout of parameter file (what does a parameter file contain?)?
Tell me about Propagate functions in informatica
What are the static cache and dynamic cache in informatica?
Explain your project of banking domian.
Is stop and abort are same in informatica?
What is target designer and target load order?
What is the use of target designer?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Differentiate between Load Manager and DTM?
Explain the shared cache and re-cache?
How can we improve session performance in aggregator transformation?
How do we call shell scripts from informatica?