Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different types of transformation available in
informatica and what are the mostly used ?
- 3 Answers
- 25463 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sailaja
Look up,Expression,update
strategy ,joiner,router,filter,sequence generator,
aggregator,normalizer,stored procedure, webservice
transformation,XML generator, XMLparser,source qualifier
Mostly used transformations are
1.Look up, Expressions
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to use pmcmd utility command?
What do you mean by filter transformation?
Explain the etl program with few examples.
What is meant by pre and post session shell command?
Mention some types of transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are junk dimensions?
have u done any performance tuning? how u ll do?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to generate sequence numbers using expression transformation?
How do you load only null records into target? Explain through mapping flow.
How to generate or load values in to the target table based on a column value using informatica etl tool.
what is degenerated dimension?
What is fact table? Explain the different kinds of facts.
