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
- 9497 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 is the Process to creating lookup transformation in informatica
What is the difference between a repository server and a powerhouse?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Differences between connected and unconnected lookup?
What is enterprise data warehousing?
How many ways are there to create ports?
What are the guidelines to be followed while using union transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is persistent lookup cache?
Mention some types of transformation?
What is session task and command task?
What are the tasks that source qualifier perform?
What are the different options available for update strategy?
What is olap (on-line analytical processing?
