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
- 9475 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sravanthi
using joiner tranformation to add two diff structure of flat files...
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the difference between Active and Passive transformation?
What is the use of transformation?
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?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain the difference between a data warehouse and a data mart?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Suppose we do not group by on any ports of the aggregator what will be the output?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is a node in Informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
During the running session, output files are created by informatica server. Enlist few of them.
In which transformation you cannot drag ports into it?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
