TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
Answer Posted / mubbasir
This can be done by passing all ports to an expression
transformation and then creating a output port say ID=1 in
both the expression transformation of each file and then
join it using a joiner on ID,hope this helps..
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
tell me 5 session failure in real time how can you solve that in your project?
tell me about your project functionality
Difference between Data and Index Caches?
What are some examples of informatica etl programs?
What are the mapping parameters and mapping variables?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Differentiate between a repository server and a powerhouse?
I have a flat file, want to reverse the contents of the flat file
What you know about transaction control transformation?
Explain how many types of dimensions are available in informatica?
What happens when a session fails and you click on recover?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps