Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
- 4 Answers
- 9269 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / pradosh
if the flat files has diff stracture then
sd-->sq-->exp>
...>join-->tgt
sd1-->sq1-->exp1>
that means take flat file source then take 2 exp transformation in which u take variabl ports i.e a=1 and exp1 is b=1 then based on condition u take a joined trans and connect to target.
join takes diferent sources
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Difference between Data and Index Caches?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Enlist the advantages of informatica.
Explain the types of transformations?
What happens when a session fails and you click on recover?
explain about unit testing? in real time?
Differentiate between sessions and batches?
Differentiate between Load Manager and DTM?
Define joiner transformation?
What are the advantages of using informatica as an etl tool over teradata?
What are data-driven sessions?
How to create or import flat file definition in to the warehouse designer?
In how many ways we can create ports?
