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
- 9478 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
Define mapplet?
How to do unit testing in informatica? How to load data in informatica ?
What is confirmed fact in dataware housing?
How to generate sequence numbers?
What are the types of presistent cache in look up tr.
Differentiate between a repository server and a powerhouse?
What is joiner change?
How to differentiate between the active and passive transformations?
generate date / time dimension in informatica
If informatica has its scheduler why using third party scheduler?
How union transformation is used?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Informatica settings are available in which file?
Suppose we do not group by on any ports of the aggregator what will be the output?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
